SQL Server 2012's INDIRECT CHECKPOINTsCommented on: 1 year ago
(July 26, 2012)
Great article on a topic that should be reviewed from time to time! Short of implementing 2012 Always On technology, we have most all of the other flavors of installations that you mention in your...
A Service Pack for a Service PackCommented on: 6 years ago
(March 15, 2007)
the old SP2 left me at a 3042 version...putting the hotfix on left me at 3050. it also left me with errors on the engine which have resulted in me opening a ticket with ms. When using management...
Recently, I've been working with a consulting client to help them tame CPU usage. Typically, they're clocking over 20,000 queries and operations per second on their e-commerce SQL Server, but ran into an issue where CPU started spiking up above 90 percent for sustained periods of time....More
What should most database administrators be doing on a regular basis? Here's a comprehensive list from Michael K. Campbell of many of the things DBAs typically do on a daily, weekly, monthly, and yearly basis....More