Posted by: virusno1 November 22, 2008
Login in to Rate this Post:
0
?
I have a question for a DBA who are in Sajha
How you monitor/Tune performance in Production Server
note: In production server, we don't have facility called Auto_update_statistics, So there is no use of DMV/DMF's I think..Guessed So!.but not sure. and Production server HAVE to be online for 24/7.
I Figured out one way. which is connecting the production server from different manchine and run sql profiler. Can you suggest any other method?
How you monitor/Tune performance in Production Server
note: In production server, we don't have facility called Auto_update_statistics, So there is no use of DMV/DMF's I think..Guessed So!.but not sure. and Production server HAVE to be online for 24/7.
I Figured out one way. which is connecting the production server from different manchine and run sql profiler. Can you suggest any other method?