November 10, 2006 at 8:07 am
hi all
i am on job of testing SQL scaler an idera product its used for stress test ( loads test)i have been arranged a demo with those guys ........well to me it looks all good but i am eager to know what constaints must be watched on in third party tools for LOAD TEST.......please let me know its a bit urgent......
thank u >> shashi......
November 13, 2006 at 8:00 am
This was removed by the editor as SPAM
November 15, 2006 at 7:15 am
Well as no-one else has answered here yet - I will add a few things I would look for during a load test.
Does the load affect any other users on the system for their reponse timings? Does it affect any other services on the server (ie reporting services, etc)
What amount of memory is being used , tempdb and Avg. Disk Queue Time
While you have their test eval inhouse - look at sp_configure and check out whether any of those values changing affect the results.
Be aware of the Indexes currently in place - Deliberately change some and see what the outcome is and how the tools identifies what to do and recommendations.
What the difference when a table has 100K rows as opposed to 10 million, etc. depending on how large your db is - see what happens to the results from the tool when the load is primararly Writing and doing inserts as opposed to just reading - Make sure you have all type of transactions being performed asynchronously - I.e. Data entry and extraction at the same time.
Can you load test with number of user emulations as opposed to just data quantity ?
Hope some of this helps - If you have a specific area you are wanting to concentrate on , just post here and thet may be a spark on what areas to associate with type of transaction you are monitoring.
I just finished reading a great article - Dunno if this will give you some pointers - http://www.sql-server-performance.com/sql_server_performance_audit.asp
** What you see, Depends on what you Thought, Before, You looked! **
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply