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 |
|
ieuuk
Starting Member
2 Posts |
 Posted - 2011-07-11 : 17:22:22
|
| Hi There,Our SQL server (SQL 2005, 500GB DB, 12GB of memory, 2 CPU) has slowly been getting slower and slower and not being a DBA I don't know really what to look for to help improve performance.Have setup and used the MS performance dashboard which seems to suggest around 160 indexes which need to be added to the database but upon running those noticed that this was using up quite a lot of disk space.Is there other things which are a better idea to run? If I need to create indexes are there others which I can remove in their place.Also am wondering if there is any articles which can help simplify the performance setup of DB's for 99% of cases?Thanks in advance,Ian |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-11 : 18:43:55
|
| [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]--Gail ShawSQL Server MVP |
 |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2011-07-12 : 02:41:47
|
| If you have a 500GB database, I would strongly suggest you get a professional DBA. I know this may not always be possible, but depending on how mission-critical your application is, you may be able to make a business case for hiring (at least) a part-time DBA. These hints and articles may help you solve your immediate problems, but there is a genuine need for constantly managing and optimising the database. One of the worst problems you can face is the database backups constantly fail and nobody notices until the server crashes and they need to restore the database. Avoid this situation by having somebody responsible for managing and monitoring the database.OS |
|
|
|
ieuuk
Starting Member
2 Posts |
Posted - 2011-07-12 : 03:00:01
|
| Excellent - thank you both for your advice and links! |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-07-13 : 01:41:44
|
| Avoid adding those indexes without thorough analysis.Also, thinking about tracking down all queries with high IO , focus on those ones through the execution plans .Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
|
|
SQL Performance Advice