Wednesday, March 28, 2012

Performance Test

When I change any SQL Settings (e.g. increasing the network packet size) I want to make a performance test before and after making this changes
Is there any easy way to do that
Thank
OlaWell... you need to decide what it is you're testing? Are you worried about
response time from an end user perspective? CPU utiilizatioin, disk
utilizatioin?
Between SQL Profiler and Performance Monitor you have the ability to capture
almost any performance metric that would be helpful. You just need to decide
what you want to know...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Olaf" <anonymous@.discussions.microsoft.com> wrote in message
news:92B5FDB4-D0DA-4D5F-8269-4130EEBB04D7@.microsoft.com...
> When I change any SQL Settings (e.g. increasing the network packet size) I
want to make a performance test before and after making this changes.
> Is there any easy way to do that?
>
> Thanks
> Olaf
>

No comments:

Post a Comment