How to perform a baseline workload test? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to perform a baseline workload test?

I will like some suggestions how to perform a baseline workload test on SQL Server 2000 SP3, SQL Server 2000 SP4 and SQL Server 2005 beta to see how the results are difference on a Windows 2003 Server.
Hm, maybe this will help:
http://www.microsoft.com/downloads/…53-893a-4aaf-b4a6-9a8bb9669a8b&DisplayLang=en
http://support.microsoft.com/default.aspx?scid=kb;EN-US;231619 —
Frank Kalis
SQL Server MVP
http://www.insidesql.de
Btw, your results will be a bit skewed since you will compare with a beta version of a software. Expect the RTM version of SQL Server 2005 to perform better than the beta. —
Frank Kalis
SQL Server MVP
http://www.insidesql.de
Why do you want to compare results between SP3 and SP4 for SQL 2000?
Are you having any issues after applying SP4? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi Satya, I have not installed SP4 yet. The main purpose for this exercise is for SQL Server 2005 beta.
Hi Frank, Thanks for the links. I have never used any of those tools you mentioned. What is the difference between using Read80Trace and running a trace file using SQL Profiler? Since I want to compare just the baseline among the SQL Server when an application is using SQL Server data, should I do some kind of monitoring using some Windows 2003 tools?
I’ve just collected these links. I have no experience with these tools. Furthermore we don’t have 2003 here. Sorry! —
Frank Kalis
SQL Server MVP
http://www.insidesql.de
Running a trace using SQL Profiler will have a minimum stress on the server as it uses the GUI control and if you already have the performance issues then its suggested to run a server side trace using stored procedures as defined in the books online. The Read80Trace uses the same topology as a command line utility which is better than running PROFILER directly. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>