If you want to identify when last time statistics were updated on objects in database then you can use either DBCC SHOW_STATISTICS header information or sys.stats catalog view. Below example displays all statistics information for the AK_Currency_Name...
If your database contains hundreds or thousands of tables then it’s difficult to find which tables are missing clustered index in a database manually. You can go through this article which provides very simple...
As a DBA, time to time we have to trace SQL queries which are consuming highest CPU utilization in SQL Server and need to tune those queries. You can refer below query which provides...
SQL Server Performance Tuning is a major topic for Database Administrators and it is also a challenge for them to trace the issues and tune it. We should know what are the major areas...
Articles / Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks / SQL Troubleshooting / Tutorials
Database performance is always a headache for Database Administrators as over the time performance may degrade due to several reasons and DBAs has to identify and fix this issue. In previous articles we have...
Articles / Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks / SQL Tools / Tutorials
Performance monitor is a free tool provided by Microsoft windows and is very useful to analyse real time and historical performance information of your database servers and windows servers. So if you don’t have...
More
