Hi, Guys I have a list of questions or doubts you can say. I will be highly thankful if someone helps. 1.Can I get a script which checks all the unused objects in your database. 2.is running dbcc on your production deproves the performance 3.What is the best way to improve the overall performance of your system. 4.what is the way to see the quries executing against you server. Urgent help will be appreciated.
Hi, 1. AFAIK for this best bet is to use 3rd party tool 2. No 3. *Performance Tunning* is generic term, but you may start with Brad's article on Performance Tunning Audit, this will help you identify issues with performance 4.run sp_who2 in QA
Just Add to that 1> You can try this article http://www.sqlservercentral.com/articles/Administering/2582/ 2> Some dbcc like check db with through analysis do cause performance issues, so you need to know when to run them or which options to use. 4> For trapping queries you can refer to Satyas blog and also SQl profiler
