A lot of DBAs including me used sp_depends several times to analyse stored procedures. I felt helpless when I understood, sp_depends is not always dependable.…
Its quite common that when there is some upgrade, change or release in application, there are chances that our database objects get modified. It may…
There are several ways to configure and start monitoring page splits on SQL Server. But now in 2012, we could make use of extended events…
Problem A few months back, I had shared a script to automate index rebuild/reorg in a database with fragmentation analysis inplace at https://www.sherbaz.com/2013/06/resumable-auto-index-rebuild-and-reorganize-script/. But that…
One fine morning, users started complaining my SQL server instance performance…They sent me a screenshot which indirectly says, their queries have timed out. I quickly logged…
SELECT v.[id], d.dirname, Count(v.[version]) MaxNumberOfVersions, Sum(v.[size]) TotalDocLibSize, Max(v.[size]) LargestDocSize FROM [dbo].[alldocversions] v JOIN [dbo].alldocs d ON v.id = d.id GROUP BY v.id, d.dirname ORDER BY 4 DESC
As part of SQL server database maintenance, the indexes have to be defragmented on regular basis by rebuild or reorganize for consistant performance. Most of…
Below query will be helpful in finding all missing indexes in a database. I got this query from one of my friend. I am not…
Below Query will help you read live file level Disk read and write information. WIll behandy for performance tuning capacity planning. select db.name,files.filename,* from sys.dm_io_virtual_file_stats(NULL,…