Server Performance

Solution Search:
These eight tips from Microsoft will allow you to tune the performance of your SQL Server with little difficulty... More...
Jul 22, 2005
Here's a list of SQL Server performance tuning worst practices, related primarily to system performance over an... More...
Mar 29, 2005
bottlenecks. This guide will help you do all that and more. It covers everything SQL Server performance, from the very best to the very worst practices and performance-tuning myths. If you'd... More...
Apr 13, 2006
bottlenecks. This guide will help you do all that and more. It covers everything SQL Server performance, from the very best to the very worst practices and performance-tuning myths. If you'd... More...
Apr 13, 2006
and troubleshooting, you're sure to find a tip or tool to help you resolve your SQL Server performance dilemmas in this guide... More...
Apr 18, 2006
and offer suggestions on how to address them with free tools and code.


Hunt down SQL Server performance problems

 Home: Introduction
 Step 1: CPU usage
 Step 2: Disk IO queuing
... More...

Dec 12, 2005

I recently spoke on SQL Server performance tuning at CFUNITED, a conference focusing on Cold Fusion, where I found a large... More...

Jul 14, 2005
Many database administrators are familiar with performance tuning. The Index Tuning Wizard allows your SQL Server to operate more efficiently... More...
Jul 22, 2005
Learn about SQL Server 2005's new features, including CLR integration, T-SQL enhancements and... More...
Feb 18, 2005
This list of free SQL Server tools will help reduce your workload, streamline maintenance and improve the... More...
Dec 19, 2005
Idera's Spotlight on SQL Server Xpert Edition is designed to detect and diagnose performance issues across your... More...
Feb 23, 2009
performance monitoring, diagnostics and tuning solution for Microsoft SQL Server that provides awareness and control over the true source of performance issues.

... More...
Feb 24, 2009
Directions and/or screenshot 1 Time period

Select a time period when you suspect SQL Server performance issues are occurring, when you are able to run Profiler and Performance Monitor at... More...

Apr 27, 2006
I'm interested in your thoughts on performance tuning multiple instances of SQL Server 2005 running on Windows 2003 Small Business Server (SBS).

I have taken over... More...

Mar 11, 2008

Without a doubt, the first metric most IT professionals use to understand SQL Server performance is the overall CPU usage, which is typically determined in one of two ways: First, you... More...

Dec 12, 2005
for the following scenario. Which offers better performance?

A) Running one server in active mode and another in inactive mode, each with four processors.

B) Running... More...
Jul 26, 2005
time monitoring and customizable alerts for fast diagnosis and remediation of SQL Server performance and availability problems. It also pinpoints common performance issues, such as... More...
Feb 20, 2009
enhance your replication techniques. It is broken up into three groups: performance, monitoring and miscellaneous... More...
Jul 26, 2005
of several must-have free tools, or go to the complete list of freebies.

  7. SQL Server performance tuning dashboard Return to Complete List

The last freebie I would like to draw... More...

Jul 14, 2005
Server Clustering Whitepapers
Protecting Server Data in Small and Medium-sized Businesses by Iron Mountain Digital
paper to learn how to successfully protect server data outside a centralized data center and focus on specific needs and requirements for SMBs.

Protecting critical...
Dell and Microsoft Windows Server 2008 Server Virtualization and Management by Dell and Microsoft
of Microsoft Hyper-V as part of Windows Server 2008, and Microsoft System Center Virtual Machine Manager, you can now take advantage of a powerful new set of tools...
Maximize the New Features in Microsoft Office Communications Server R2 by Global Knowledge
to their IP PBX product Office Communications Server (OCS) 2007. Several great features and enhancements to Microsoft's existing product make OCS 2007 R2 a significant...
Top 10 Tips for Successful Access Control by FoxT
fine-grained access controls in a corporate server environment. Fine-grained access controls are key to establishing secure access to enterprise resources and...
Evolution to Revolution: Landmark Technology Decouples Hardware from Software to Cut Cost and Complexity by CDW Corporation
the similarities and differences between server virtualization and client virtualization. Which one holds more benefit for your organization?

Computers have become...