Troubleshoot high CPU issue without using profile traces

  The scope of these issues is very wide but I would discuss about the approach which I follow to resolve these issues. I have resolved more than 50% of the cases by using this approach without even looking at profiler traces. I hope this will help you troubleshooting issues in your environment. It’s specific…

6

In SQL server, How to see the standby file path when we restore the database in standby mode:

  I was answering to the questions on Social.msdn.microsoft.com forum site, Someone posted the question :  How to see the standby file path when we restore the database in standby mode:  I checked lots of DMVs e.g. msdb..restorefile, msdb..restorehistory etc. but couldn’t find any place to get the standby file name. I Spent around 1-2 hours…

1