I am using SQL server 2005 sp2 on windows 64 bit server .When I run predefined reports under summary (F7) tab in sql server 2005 ,I saw during that periode ,there were high CPU spike .I checked in monitoring tool Idera .I saw there is one process ran 30
minutes using Master databse ,it cause high CPU spike .I dont know which reports cause high CPU spike .Is there any way I can find report name or location ?
Any one can help me to figure out
1) why this report took 30 minutes to run report ?
2) From where can I find explaination of built in reports under summary tab ?
3)Is it good idea to run predefined reports during production hours?
4)which is the proper way to check daily database statistic ?
View Complete Post