October 2008 - Posts

Drum Roll, Please...The Debut of The SQL DMV All-Stars Dream Team!
The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 provides us with all manner of wonderful information, much of which was heretofore difficult or even impossible to get. Yet I often hear confusion about their use. People ask, "But Read More...
Posted 30 October 08 10:29 by Jimmy May | 7 Comments   
Filed under , , , , ,
Attachment(s): DMV_All-Stars_v20090701.sql
Is Twitter the YouTube of 2008?
Always in pursuit of the elusive creature known as Work/Life Balance, I discard activities which monopolize my scarce bandwidth. I even struggled with tagging this post under "Productivity". Yet it struck me that Twitter was reaching critical mass, so Read More...
Posted 19 October 08 01:24 by Jimmy May | 3 Comments   
Filed under , , ,
PerfMon Objects, Counters, Thresholds, & Utilities for SQL Server
I’m frequently asked questions about which PerfMon counters to use & what thresholds to rely on. I’ve been amalgamating this information for years in the form of an Excel workbook: PerfMon_Counters_Digest_w_Vital_Signs_Correlation_v6.xls . The current Read More...
Posted 15 October 08 09:44 by Jimmy May | 7 Comments   
Filed under , , , , , ,
Attachment(s): PerfMon_Counters_Digest_w_Vital_Signs_Correlation_v6.xls
Disk Partition Alignment (Sector Alignment) for SQL Server: Part 1: Slide Deck
<Note: 20081119: Deck updated w/ new graphics, perf metrics, & dynamic disk info> <Note: 20090225: Deck updated & moved to skydrive > <Note: See also Disk Partition Alignment (Sector Alignment) for SQL Server: Part 4: Essentials Read More...
Posted 14 October 08 11:57 by Jimmy May | 18 Comments   
Filed under , , , , , ,
Attachment(s): DPA Deck Info.txt

Search

This Blog

Syndication

Page view tracker