Tag Archives: Query

Wait Statistics……What to worry for?

Answering the message “Hi, yeah, the server is slow. Thanks. Bye.” Continue reading

Advertisements
Posted in ms sql, Performance Tuning, Troubleshooting, Uncategorized | Tagged , , , , , , , , | 1 Comment

Q&A Backup_001

Common questions regarding SQL Server backups Continue reading

Posted in backup, ms sql, Performance Tuning, Uncategorized | Tagged , , , , , , | Leave a comment

Transaction Tracking Continued

Second part in two part series blog regarding transaction tracking through logs and point in time restore Continue reading

Posted in Best Practices, ms sql, Troubleshooting, Uncategorized | Tagged , , , , , , , | Leave a comment

Finding a Transaction in the log for a particular user

As a DBA, this is a frequently asked question from the developers “When was a certain insert/update/delete performed on a specific table?” Or, It is simply required to know the time of the particular transaction so that it can be … Continue reading

Posted in ms sql, Troubleshooting, Uncategorized | Tagged , , , , , , , | Leave a comment

SQL Server Storage Report

When working with Oracle databases, especially Oracle Cloud Control 12C, it was easy enough for me to generate a daily report early morning that would be mailed to all the stakeholders regarding the Storage Usage for all the Oracle instances. … Continue reading

Posted in ms sql, reporting | Tagged , , , , , , , , | Leave a comment

How To Identify The Source Of Page Splits

In my last post I talked about how one could go about troubleshooting an issue in SQL Server, and today I would like to talk about one of the common issues that most DBA’s come across their professional career, Page … Continue reading

Posted in ms sql, Performance Tuning, Troubleshooting | Tagged , , , , , , , , , , | Leave a comment

Find the locks

There are many blog posts on the internet that have explained time and again regarding this topic. Many of them are pretty basic stuff while some of them are quite advanced. A while back I myself wrote a blog post … Continue reading

Posted in Uncategorized | Tagged , , , , , | Leave a comment