The Weekly SQL Server Show – Watch Now
This show is an interview with Kim Tripp and Paul Randal. We got together at DevConnections in Las Vegas and talked about everything from the famous board game to SQL Server 2008.
Many Things Can Impact Query Performance
Once you work through your systems, reviewing calls, reviewing indexes, checking your database structures… Once you have reviewed the server to see the memory and CPU utilization but can’t find the issue, it’s time to look at new information. Take a look at Confio Ignite. With the Confio tools, you’ll be able to see actual query response time – and you’ll see what items along the way impact performance. Find out how things are running based on what your users are really seeing – not what the server is seeing. Check out Confio Ignite and get… the rest of the story. Get more information here.
Just 30 minutes of your time… you’ll find out about …
Troubleshooting and Maintaining SQL Server 2005
Find out about how to dig into your system and pull information you need to know to understand what’s happening. We’ll look into performance monitor counters to keep track of, where logs are that you should be aware of and more. The goal of this session is to have you feeling comfortable with performance profiling and investigation approaches for your system.
> Register Now
> Nov 20 2007 12:00pm Noon Pacific (TODAY)
Over the Holidays…
Increase your chances to actually HAVE a holiday. Put your plans down in writing – recovery, backup, troubleshooting. Make sure it’s possible for someone to step in and at least take basic steps to get and keep your systems running in your absence.
Now is the time to get these plans in place. Think about first steps to address issues, think about things that happen on your systems that you need to address on a regular or semi-regular basis. From this list of items, you can make checklists to address those items – steps that anyone can follow to correct the issues.
I understand if you don’t want to hand over the keys to the kingdom, but you can still let someone help with the more basic of steps to address predictable happenings.
Give yourself a chance at a break as we start into this holiday season. Being THE critical path is something to avoid if at all possible.
Featured White Paper(s)
Top Ten Steps to Secure Your SQL Server
In most organizations today, business critical and confidential data increasingly resides in Microsoft SQL Server databases. … (read more)
Addressing the Persistent Problem of the I/O Bottleneck in SQL Server Applications Through a RamDisk Software Solution
This white paper describes the I/O bottleneck problem that occurs when using SQL and the pain points for which it is responsi… (read more)
Microsoft T-SQL Performance Tuning Part 2: Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server using Indexing Strategies
This white paper, authored by SQL Server expert Kevin Kline, discusses the basics of indexes, such as density and selectivity… (read more)
The High Performance DBA: Optimizing Databases for High Performance
The combination of a cross-platform environment, added database complexity, more data, and less headcount has become a real c… (read more)