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…
Read More >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…
Read More >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.
Read More >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.
Read More >