Re: stress by profiler ?
From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 07/19/04
- Next message: BigA: "Maintenence Plan"
- Previous message: Hari Prasad: "Re: Real Time Backup Practises"
- In reply to: sonbaby: "stress by profiler ?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 19 Jul 2004 11:01:08 +0100
Are you running the Profiler on the same machine as SQL Server? Where is the
Profiler output being logged to? to the same disk as your data and log
files?
Anyway, running Profiler is CPU intensive and has an impact on the
performance of the system. That's why it is not recommended to run Profiler
on busy production servers, unless absolutely needed, for some
troubleshooting.
You might want to start using server side tracing procedures. For more
information on this, read my article at:
Automated server side tracing in SQL Server
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
-- HTH, Vyas, MVP (SQL Server) http://vyaskn.tripod.com/ Is .NET important for a database professional? http://vyaskn.tripod.com/poll.htm "sonbaby" <sonbaby@discussions.microsoft.com> wrote in message news:98E26852-58D1-4D86-B92E-C455AF5FFC0D@microsoft.com... We've got a strange result during stress test .. First, we generate multi threads in order to simulate the multiple concurrent user environment.. The performance monitor shows good CPU usage, memories.. and so on.. The response time of DB access is also good. But, whenever we start up SQL profiler to logging the SQL Server states, the response time of DB access is dramatically degraded.. (The transaction isolatsion level of these DB Accesses are set by "read uncommitted", that means.. no locks, no waits.. The result of profiler is -- very short CPU -- very low Disk Read -- high duration time... EX) duration cpu disk i/o 5360 0 595 5570 10 506 4460 20 672 I don't understand this result. Is there any secret for SQL Server Profiler ?
- Next message: BigA: "Maintenence Plan"
- Previous message: Hari Prasad: "Re: Real Time Backup Practises"
- In reply to: sonbaby: "stress by profiler ?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
