Posted by Erland Sommarskog on 11/28/07 13:52

Manish (marora@gmail.com) writes:
> How does the database perform and what is the criteria for the
> performance matrix? To clarify, how will one collect performance data
> related to MS-SQLserver?

You can use performance counters, Profiler, query dynamic management views.

> What is the criteria for collecting such data?

I'm afraid that I can't answer why you would like to collect some data.
Or I am not understanding your question.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Connecting to Double Byte Progress (MFG-PRO) databases from SSIS...
• Prev in forum: Re: Select distinct rows from duplicate rows....
• Thread view: Re: Clustering, Security, Performance, Load Balance

[Reply to this message]