Browse By Category

February 19, 2003 05:19 PM

Shorten Your Sampling Interval for Performance Monitor

Rating:

(0)

SQL Server Magazine

InstantDoc ID #37712

I'm trying to create a baseline of SQL Server performance by using information from the Windows 2000 Performance Monitor. Performance Monitor's default refresh rate for sampling information is 15 seconds. Would lowering this default value and sampling more often create an excessive burden on the server?

...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

Professional Membership

Monthly

Annual

Monthly

Annual

Compare Member Benefits

Add a Comment

There are no comments to display. Be the first one!

You must log on before posting a comment.

Are you a new visitor? Register Here

SQL Server 2005 (T-SQL performance and processors)

Hi, I have the query below , this query runs fast in some servers (SQL Server 2005 servers) and run very very very slow in other servers. In the f...

More Posts

Installed value from SP_GET_DISTRIBUTOR
NVARCHAR to Excel
Stored Procedure - Tuning and Optimization

Essential Guides

Choose the Right Storage Architecture for your SQL Server Environment | Overwhelmed by the many different storage platforms available in today’s SQL Server market? Wendy Henry discusses how choosing the right storage for your environment does not have to be a confusing process.

Web Seminars

Database Schemas: Getting it Right the First Time | Database modeling and design are at the core of a healthy database management and performance foundation. Getting it right the first time will enhance the bottom line in a variety of ways.View this on demand web seminar

eBooks

Playbook for a Virtualized Datacenter | Organizations are looking to extend virtualization to encompass the entire datacenter. This playbook provides you with a step-by-step overview of the benefits, challenges, technology options and best practices for datacenter virtualization.

eLearning Series

Windows IT Pro brings the experts direct to you to share their real-world perspective, experience, and expertise. During each event, three sessions stream in real time, allowing you to learn, to ask questions, and to get solutions.
Upcoming event: SQL Server Consolidation

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.