I am a new in SQL. I have a test system in which I have access to the trace files which gets updated often from the production. I have a development system with remote access to it (SQL Server 2000 on Windows 2003 server) and it is a cloning of the production server and they update the database often here, manually. 1) My manager has asked me to reproduce the trace files from the test system on the 2000 server (remote one) and check the performance. 2) They also want me to run the Perfmon in the Windows 2003 server and generate a report. There are many issues with deadlocks and stored procedures here and migration is also going on parallel. They have asked me to run Perfmon in Windows 2003 server and replay the Profiler traces in the SQL 2000 server to create a baseline and compare the same with the new upgraded box. My questions are 1) How can I import the trace files(updated frequently from the production) in my desktop to the 2000 server, to which I have remote access ? 2) Is it possible to replay these trace files there and how to check the performance ? 3) Do I need to run the Perfmon while replaying the traces and generate a report ? 4) Do I need to create 2 reports (from Profiler and Perfmon) to check the baseline ? Any suggestion would be appreciated and thanks in advance.
I am a new in SQL.
ReplyDeleteI have a test system in which I have access to the trace files which gets updated often from the production.
I have a development system with remote access to it (SQL Server 2000 on Windows 2003 server) and it is a cloning of the production server and they update the database often here, manually.
1) My manager has asked me to reproduce the trace files from the test system on the 2000 server (remote one) and check the performance.
2) They also want me to run the Perfmon in the Windows 2003 server and generate a report.
There are many issues with deadlocks and stored procedures here and migration is also going on parallel.
They have asked me to run Perfmon in Windows 2003 server and replay the Profiler traces in the SQL 2000 server to create a baseline and compare the same with the new upgraded box.
My questions are
1) How can I import the trace files(updated frequently from the production) in my desktop to the 2000 server, to which I have remote access ?
2) Is it possible to replay these trace files there and how to check the performance ?
3) Do I need to run the Perfmon while replaying the traces and generate a report ?
4) Do I need to create 2 reports (from Profiler and Perfmon) to check the baseline ?
Any suggestion would be appreciated and thanks in advance.