SP_What is smarter than SP_Who2
SP_What is smarter than SP_Who2! We’ve seen many DBAs scratch their head to find out who is running what in SQL Server. When a user complains about the database performance issue, the first thing DBAs do is run SP_Who or SP_Who2 to see what may be happening in SQL...
Optimize for Ad Hoc Workload in SQL Server
When a query is executed, it compiles and generates an execution plan and stores it in the plan cache. If this is a one time query that will never be run again, then the newly generated plan and space in plan cache are wasted. This means the buffer pool now contains a...
Data and Log File Performance Using Instant File Initialization
Ever wondered why SQL Server takes long time to perform below operations? Create a database Expand data files for additional growth Automatic data file growth due to auto-grow settings Restoring a database, etc. Today we will be looking into a powerful and yet not...
The only audit you'll need for production databases!