RE: What all performance reports would you like to have in the SQL server?
From: Nilesh Oswal (nilesh_oswal_at_persistent.co.in)
Date: 07/21/04
- Next message: Hari Prasad: "Re: Query Performance Question"
- Previous message: Hari Prasad: "Re: Converting MSDE databse to mixed mode"
- In reply to: Vikram Jayaram [MS]: "RE: What all performance reports would you like to have in the SQL server?"
- Next in thread: Vikram Jayaram [MS]: "RE: What all performance reports would you like to have in the SQL server?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Jul 2004 21:42:54 -0700
Hi Vikram,
If you are asking about how frequently the performance counters would
be collected, it would depend on the nature of that parameter, for
example a parameter like CPU usage would be measured more frequently as
compared to disk usage. The statistics for past 'n' days would be stored
in a database so you would be able to see how an object/ parameter has
been performing over the period of past n days something like usage
trend for a parameter.
Btw, thanks a lot for the pointing out need for a report on backup
history. Please feel free to suggest any such reports that you think
might be useful to the DBAs/normal users.
thanks,
Nilesh
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
- Next message: Hari Prasad: "Re: Query Performance Question"
- Previous message: Hari Prasad: "Re: Converting MSDE databse to mixed mode"
- In reply to: Vikram Jayaram [MS]: "RE: What all performance reports would you like to have in the SQL server?"
- Next in thread: Vikram Jayaram [MS]: "RE: What all performance reports would you like to have in the SQL server?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
