TempDB latch timeouts with lots of RAM
Recently I had an interesting problem where the SQL Server 2008 R2 instance would randomly in the middle of the morning start having latch timeouts on various tempdb database pages. The first assumption was that these pages were GAM pages and that more tempdb database files would solve this problem. However looking at these pages, […]
If you could give an aspiring DBA just one piece of advice what would it be?
Probably the best advise that I could someone entering the field of Database Administration would be to keep learning. If you think that you know everything that their is about this product that we deal with day in and day out called Microsoft SQL Server, you are wrong. There are so many little pieces to […]
SQL PASS Booth Prize Winner
At the SQL PASS Summit this year we had the privilege of being the co-sponsors of the Consultants Corner booth. As part of our sponsorship we opted to give away a $1000 Amazon Gift card. The winner of this years prize is…. Kerry Tyler So congrats to Kerry, and thank you to everyone who came […]
#sqlpass Keynote Day 2
Today was the 2nd day of the SQL PASS conference, and as always there was a keynote. Todays keynote was by Douglas McDowall who is the VP of Finance, Thomas LaRock who is the VP of Marketing, followed by Dr. David Dewitt from Microsoft. Douglas talked to the members at large about the financial health […]