<div>
Thanks for the feedback. &nbsp;I contacted a local associate to provide some further assistance as this i out of my skill-set.
</div>


Thanks for the feedback.  I contacted a local associate to provide some further assistance as this i out of my skill-set.

<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I have a buddy with a Windows hosted server running Navision and MSSQL. &nbsp;I am not an SQL guy by any stretch of the imagination.<br />
<br />
He says that the server is fast but Navision is slow with the queries. &nbsp;I think it's his sql database and maybe log tuning etc.<br />
<br />
In the MSSQL programfile directory, he's got 26 mssql.xx files with MSSQL.1 = 39GB and <br />
MSSQL.15 = 30GB being the largest and he doesn't know why.<br />
<br />
How can I help him fix this?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/04_w17/650028/sqlFolders.PNG" target="_blank" title="screentshot (20 KB)"><img alt="screentshot" class="file-block lazyload" style="max-width: 324px;" data-src="https://filedb.experts-exchange.com/incoming/2013/04_w17/650028/sqlFolders.PNG" /></a>
</div>
</div>


sqlFolders.PNG

Hi all,

I have a buddy with a Windows hosted server running Navision and MSSQL.  I am not an SQL guy by any stretch of the imagination.

He says that the server is fast but Navision is slow with the queries.  I think it's his sql database and maybe log tuning etc.

In the MSSQL programfile directory, he's got 26 mssql.xx files with MSSQL.1 = 39GB and 
MSSQL.15 = 30GB being the largest and he doesn't know why.

How can I help him fix this?



MSSQL slow with Navision

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Microsoft Dynamics

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.