Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2004-05-13 : 10:38:35
|
| New modules are being added to my DB server. I need to find the affect of these modules on the DB server. I don't want to run a continiuos trace on the server every time i add a new module.Following are my thoughts to implement this.1>Capture the trace ONCE on production server.2>Reapply the trace on a STAND BY SERVER.Following are my doubts?a>Is it possible to reapply the trace on a second server? If YES will this trace create the same load (same environment)on the second server?b>Can i increase the load from the trace, like in some testing tools where if the trace gives the connections 10, user can manually increase theconnections to 20 just to find out what will be the performance hit if the no of users double?c>Is there a better way?------------------------I think, therefore I am |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-13 : 13:12:22
|
| I'm curious as to why you don't know when new database objects are put onto your server. Before objects are placed in production, they should have been thoroughly tested for impact to the application as well as impact on performance. You need to restrict access so that the DBA has control of this. I've never reapplied a trace on another server. We use Rational tools to test this type of thing.Tara |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-05-14 : 02:20:19
|
| We test all the objects before putting them to the server. But we are not able to estimate the effect of these modules (like performance..)before putting them on the server. Because server (web server) will be accessed from all over the world. Hope this is clear.Do you use rational tools on the production server? Can they be used on a DB server? Will they affect the server performance if we use them on the DB server? I believe rational is now IBM product..we may have to get the licence..Is there an evaluation version?------------------------I think, therefore I am |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-14 : 12:14:30
|
| We only use Performance Monitor and SQL Profiler in production. We do all of our performance testing in a performance environment. We've got 5 different environments. Dev, Unit test, QA, performance, and production. Before applications make it to production, they go through the previous 4 environments.Don't know about licensing of Rational tools.Tara |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-05-17 : 03:18:27
|
| Thank you.------------------------I think, therefore I am |
|
|
|
|
|
|
Reapplying Trace