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 |
|
Dapo
Starting Member
4 Posts |
 Posted - 2008-09-18 : 04:57:32
|
| I want to start mornitoring my database for efficiency, availability and perfomance optmization. I need a guidiance from the basics how I am to do it. |
|
|
lepeniotis
Yak Posting Veteran
75 Posts |
Posted - 2008-09-18 : 05:01:54
|
| You can use idera tools for monitoring. I use the Operations manager 2007 but I think this couldn't help you enough if its only for one database. For performance tunning you can use this solution which is really good actually. http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.htmlRegards.MSc Advanced Computing Science MSc Database ProfessionalSheffield Hallam UniversityMCP (70-229, 70-228)Industrial IT Engineer |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-18 : 08:25:40
|
| Check out Tara's Blog. She has lots of good stuff for optimizing database. |
|
|
|
|
|
|
Performance Tuning