Online Help > Support/Resources > Troubleshooting > Data Sources > SQL Server

Troubleshooting SQL Server Performance



Whenever the performance of queries against SQL Server decreases, check on the following.


Size of database files

If you transaction log file is enormous, it may be that the recovery model of the database is set to FULL, which means that it requires regular backups in order to clean up past transactions.


You can confirm this is in the properties of the DB itself



The most urgent step is to perform a full Backup of the  


Run the following statement against the database


exec sp_spaceused