July 21, 2008 at 10:06 am
Hello Guys,
Has anyone done load or performance testing on SQL Server 2005, also do we get any softwares online using which we can do the tests. I need to test replication, so if anyone has any ideas as to how it can be done and also which softwares to be used.
Any help would be appreciated as I need to do something soon.
Thanks,
Nikhil
July 21, 2008 at 10:26 am
I've done a ton of testing of SQL Server 2000 and 2005. I've never tried load testing replication before, so I'm not sure of anything that would help you there.
The tools I've found most useful are Quest's Data Factory and Load Factory, Red Gate's SQL Server Data Generator. I've tested Idera's SQLScaler. It's a great tool, but there are a couple of things we do with Load Factory that you can't do in SQLScaler, so we haven't moved to it, yet.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 21, 2008 at 12:07 pm
You can use a replay trace (SQL Profiler)
July 21, 2008 at 12:15 pm
Replaying Trace does work. It's a bit of a pain to set up, but it does work. However, a Trace is dependent on you already having a database and application functioning somewhere at a high enough level that you can capture it's behavior. If you don't have this, then Profiler won't help. Profiler playbacks are also limited to doing exactly what you asked it to (although I saw this just today) and no allowance can be made for modifying parameters or introducing new queries. I'm not against it. I just hate the lack of flexibility.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 21, 2008 at 1:03 pm
Thanks a tonn guys... for all the help....
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply