As a professional maintaining and managing databases for clients I am very well aware of the fact that Data Integrity in relational databases is absolutely crucial. As DBAs the data we maintain and support, is in many cases the organization’s most important asset. Data Corruption is a topic for it self that I will not …
Perform DBCC CHECKDB Data Integrity checks on Log Shipping Secondary server Read More »
If you have read my previous post on how to capture the Blocked Process Report event then checkout this script that queries the data captured in the event
For the TraceBlockedProcessReport stored procedure presented in this post see my Traces project at GitHub. This is from the Microsoft’s official documentation “The Blocked Process Report event class indicates that a task has been blocked for more than a specified amount of time. This event class does not include system tasks or tasks that are …
Capture SQL Server’s Blocked Process Report event Read More »
Years a go when working on a .net project I came across log4net and thought I will give it a shot. Using log4net in my project I immediately saw the advantage of using this logger and adopted it ever since replacing my home made hand crafted logger. Checkout the features page of log4net. As time …
Before moving forward be sure to have read this previous post that is the basis for the current post. This is the link to me GitHub diskspd project containing the relevant files discussed in these 2 blog posts mini serious. Working quiet often with diskspd it was only natural for me to automate the tiring …
If your server is stressed out on CPU I am pretty sure you would benefit using these queries to correctly identify and prioritize your course of action. The first query is the simplest as it only retrieves data from sys.sysprocesses so when a server is really stressed out on CPU and queries take long to …
This is the link to my GitHub diskspd project diskspd was designed as a storage testing tool and that basically mean test your SAN or NAS but not only SAN/NAS based disks, you can test any other disk, be it a DAS, a local drive on your server or your new laptop’s SSD (I always …
Using diskspd to test disk performance with SQL Server Read More »
