Author: Prashant Kumar

Scenario I use Ola Hallengren’s famous backup solution to back up my SQL Server databases. The destination for full backups is a directory on local disk; let’s say D:\SQLBackup\ If you are familiar with Ola’s backup scripts, you know the…

While looking at a SQL server health report, I found affinity mask parameter in sp_configure output showing a negative value. name                                minimum     maximum     config_value run_value ———————————– ———– ———– ———— ———– affinity mask                       -2147483648 2147483647  -1066394617  -1066394617 Affinity mask is a…

I recently worked on a case where Service Pack 2 for SQL 2008 clustered instance failed with this error (Summary.txt). The resolution (or workaround I would say) is simple, use a local disk to launch SP2 setup, here’s a step by step how to.

In this blog, I am going to demonstrate how we can use the wait event category sqlos.wait_info* to track the wait resources the queries running in a particular session undergo.