Tip

Turn off services, hike performance

To squeeze more performance from a SQL Server application server, consider turning off operating system services unrelated to core OS functions and SQL Server itself. Doing so helps release additional memory and lower your CPU utilization.

To see what services are running on your system, open the Services control panel. You can either disable unnecessary services, or set these services to manual. A manual setting requires you to physically start the service, either from the command line or in the Services control panel.

There is a long list of services that don't really help SQL Server perform its work. Assuming that your server is dedicated to SQL Server (if not, be careful what you turn off), you may find that messaging services such as Alerter, Fax Service, Intersite Messaging, and Messanger aren't required. Additionally, many Internet utilities can be turned off, including: FTP, Internet Connection Sharing, Kerberos Key Distribution Center, NetMeeting, QoS, Remote Access Connection, RRAS, SMTP, Telnet, and WWW. Since you won't be using other applications, consider eliminating Application Management, Distributed Link Tracking Server, Network DDE and DDE DSDM, RPC Locator, RunAsService, Utility Manager, and Window Installer. The Indexing Service and File Replication service are worth disabling, as well.

What you turn off depends upon the configuration of your system, and its intended use. Don't turn off the Print Spooler Service, for example, if you

    Requires Free Membership to View

intend to print from this particular SQL Server. But it is certainly worth experimenting with these background services.

Barrie Sosinsky (barries@killerapps.com)is president of consulting company Sosinsky and Associates (Medfield MA). He has written extensively on a variety of computer topics. His company specializes in custom software (database and Web related), training and technical documentation.


This was first published in May 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.