Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-09-28 : 01:43:11
|
| Dear All,From the one week back i have took the responsibility of DBA.Till now was feeling good,,I am very beginning to DB tuning where one of my manager ask me to do the following."We are experiencing performance issues on websites connecting to the SQL01 prod DB.Can you please do a performance review on the DB, investigate what is causing the speed issue, and resolve the issue"If somebody helps me in tracking 1.what and all i needs to check2.which tool i need to use 3.Do i need to check particular DB4.Any help in investigating above issue will save my Job Thanks In advance,Gangadhar |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-09-28 : 04:50:57
|
| [url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url][url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]If it's critical and, as you say you have no idea where to start, tell your manager that you don't know how to do query tuning and see about getting a consultant in. It's not an area you can learn in 10 minutes.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Performance Tunning of SQL server