Hey, Everyone… our annual get-together of SQL professionals is happening on May 7th, at UNF, here in Jacksonville. I will be speaking at 9 AM on breaking into the world of Azure & PowerBI, using (mostly) the skills you likely…
Category: Performance Tuning
SQL Saturday Jacksonville, May 10, 2014
Hey, everyone! There’s a great event here in Jacksonville, Florida. It’s coming in May. It is like a mini Tech-ed. Free Food. Great Technical presentations. Click the picture to the right to register! Lots of networking. Fellowship. Swag. After hours…
When were your statistics last updated?
Introduced in sql 2005 the following query will tell you the date your statistics were last update for each of indexes of a table…
MSDB db too big?
Microsoft provides “sp_delete_backuphistory ‘6/1/2011’“. However, this can take a very long time unless you also add indexes to the backup table. This is what did the trick for me: Create Nonclustered index idx_backupset_finishdate ON backupset (backup_finish_date) INCLUDE (backup_set_id, media_set_id) What…
See your servers’ performance real-time
I have posted an article to enable you to compare your servers’ performance in real time. It’s one of my favorites. It won’t run on systems older than 2005. You’ll find it here.
Performance counter types
Learning about Performance Counters How do you interpret the value you get back for any particular performance counter?
SQL PASS Rally
May 11, 12, 13. Steve is presenting on performance tuning in Orlando.