Browse by Tags

All Tags » Performance Tuning   (RSS)
Fixed Cycle Applications
26 September 08 06:30 AM | Buck Woody | 1 Comments   
I was working with someone last night on some performance tuning and noticed that they didn't have a specific issue that was causing their system to slow down - it was a combination of things. As we were working, I found a bunch of things that were running Read More...
The Quickest Route to a Custom Collector
24 September 08 06:30 AM | Buck Woody | 1 Comments   
The Data Collector feature in SQL Server 2008 is a new way to automate the gathering of any data from SQL Server you want to store historically. Combine that with the Management Data Warehouse and Custom reports, and you have a powerful monitoring and Read More...
Time-based Optimization
14 March 08 09:02 AM | Buck Woody | 0 Comments   
One of the primary jobs of both developers and DBAs is optimization, or its more common name, performance tuning. Lots of the management tools improvements for SQL Server 2008 are aimed at performance, such as the new activity Monitor. Using the tools Read More...
Speeding up encryption
27 August 07 08:18 AM | Buck Woody | 2 Comments   
A friend of mine from Tampa, Florida wrote me the other day with an interesting observation: "I have a small finding and don't know where to publish it. Maybe you can help get the word out via your blog? OPEN SYMMETRIC KEY is somewhat costly to execute. Read More...
Index Overlaps
21 August 07 10:32 AM | Buck Woody | 0 Comments   
There are a lot of tools in SQL Server 2005 that will help you with indexes, from enhanced plan diagrams to the Database Tuning Advisor. But I was scouting around this morning for a script that would find places where I had indexes that included duplicate Read More...
Page view tracker