DBCC CloneDatabase
This blog was due from a long time. With the release of SQL Server 2014 Service pack 2, a new DBCC command included that is DBCC CloneDatabase. My primary job role …
Read MoreTag: Performance troubleshooting
SQL Server Identify Long Running Queries
sql server identify long running queries It is always a big challenge to maintain application’s performance optimum. Increasing data on regular basis is often the cause for performance degrades. In most …
Read MoreSQL Server: performance series – PAGELATCH_ and PAGEIOLATCH_ wait types do not wait until its too late!
Contention is the word that you need to concentrate in resolving the performance issue, page latches contention is common in multi-CPU systems due to the nature of when multiple threads concurrently …
Read MoreSQL Server: Why is it necessary to capture and store information on sessions i.e. spid(s) running on a SQL instance for troubleshooting purpose.
Many a times a DBA wishes for the below information, during performance troubleshooting, Can I get to know what was being executed 30 minutes back. Can I get to know which …
Read More