SQL Server Performance

Performance Tuning

Discussion in 'Performance Tuning for DBAs' started by lara99, Oct 17, 2007.

  1. lara99 New Member

    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.
  2. ghemant Moderator

    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
  3. techbabu303 New Member

    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

Share This Page