NOTE: 

The contents of this page have been incorporated into a more comprehensive page at https://culturatech.atlassian.net/wiki/x/AQAXJQ.  Please use that page.


Problem

MSSQL is not running as fast as it should...  Where should I look?  

Solution

Check your Database properties in Microsoft SQL Server Management Studio.


Size = current size that the MSSQL database is holding. 

Space available = Should be set to consider a standard "reserved" area to not require MSSQL to continually increase the database size. 


Your memory available for a MSSQL server should always be Total ram - 4GB for OS operations as a guideline. 



Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.



Related issues