Viewing 15 posts - 1 through 15 (of 24 total)
Thank you for the script. It's a really quick way to look at a table. Sometime, unfortunately, I am tuning "on the fly" and this will help.
November 18, 2014 at 7:58 am
No sure if I am too late for this, but this happened to me two weeks ago. After checking all the usually suspects, I ran Adam Machanic's sp_whoisactive. ...
October 31, 2014 at 9:12 am
Very useful. Thank you.
August 13, 2014 at 8:00 am
You may already be doing this, but if you set an alert to email you anytime there is an auto-growth, you may have a better shot at catching the offending...
June 17, 2014 at 7:54 am
Thank you for the script. Very useful for us small shops on a Budget.
May 19, 2014 at 9:26 am
I also recommend the free tool, but if for some reason you cannot, this link from SQL Soldier is worth looking at.
March 20, 2014 at 9:07 am
The easiest way is to manual run the copy job and then manual run the restore jobs to get things back in sync. I have had this happen to...
February 21, 2014 at 2:32 pm
Here is a great tool from Brent Ozar. He presented on it at PASS and the name of his session was "Why is my server slow, right now?
January 21, 2014 at 7:39 am
I am not sure if you got a complete answer yet, but I had the same issue last year. The auditors required that the SQL logins have an expiration...
November 6, 2013 at 8:11 am
I did this on one of our servers last year. Everything came back except the SQL Server Agent would not start. I had to change the path in...
October 31, 2013 at 7:26 am
This is laughable. The speaker I am looking forward to the most at pass is a women. An I am sure other feel the same way. Real...
August 28, 2013 at 8:20 am
I use sp_whoisactive; it has saved my life, but I also you the two scripts below when I need a little different info. You can comment out the where...
June 13, 2013 at 2:38 pm
As always, it is not advisable o shrink a database unless it is an extreme circumstance, like you are running out of disk space, but it can be done. ...
June 13, 2013 at 2:30 pm
Here is a great article from SQL Diaries that shows the steps to clean up your maintenance plan.
April 29, 2013 at 7:39 am
It might be helpful to clear your wait statistics, and start to monitor again. I agree with Gail, in that after a couple of months, it is difficult to...
March 13, 2013 at 7:59 am