I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch.
SSDs are a Game Changer for SQL Server Storage
No, session is not exclusively about SSDs. But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks. As Bob Dylan said ''Times, they ...

One last reminder - If you're interested in learning more about troubleshooting and optimizing SQL Server performance, please consider coming to the full-day seminar I'll be giving this Friday. Full details are here: http://sqlperftuning.eventbrite.com/. We'll be working some exercises, so bring your laptop with an instance ...

Join Us for 24 Hours of SQL Server Training
(with a special focus on SQL Server 2008 R2)Did I mention that your Cohorts in Crime
(that be me
and Brent
Ozar) are presenting?!?
The FREE 24 Hours of PASS event is bringing an exceptional
lineup of SQL Server and BI experts to your computer starting at
12:00 GMT (UTC) on May ...

It seems like questions always come up about how to monitor memory. But each time the question comes up, it’s slightly different.
Here’s a sort of FAQ for memory questions:
1. How can I figure out memory and CPU consumption by database?
a. In SQL Server 2005, DMVs are of course the way to go. Pre-SQL ...

You might encounter a situation, under a very heavy workload, where processing for certain transactions starts out very efficiently, but over time becomes much less efficient.
A good place to start troubleshooting is, of course, PerfMon. But PerfMon can fail to reveal the culprit, since the CPU can remain stable and moderate ...