Post reply

Load test, Performance Test

  • July 21, 2008 at 10:06 am

    #194180

    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

    #845871

    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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • July 21, 2008 at 12:07 pm

    #845934

    You can use a replay trace (SQL Profiler)

  • July 21, 2008 at 12:15 pm

    #845942

    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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • July 21, 2008 at 1:03 pm

    #845970

    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