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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Performance Measures

Author  Topic 

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2010-06-22 : 01:04:29

Over the years there was a growth in the databases under each production server, which is is quite normal for any business to happen.

I have done with various reports like the Growth of databases; Log Growth; Buffer Cache parameters,Blocking Issues, apart from finding the Sizes of the Server parameters and table sizes; Capacity Planning


How to check the parameters relating to Memory allocations which resembles with Buffer allocation; I/O parameters and any others, which might co-relate with the performance measures onto the server and its underlying databases.

Thanks a lot.

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2010-06-24 : 20:16:24
Can anyone please respond to this snippet
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-24 : 20:28:10
You've posted too broad of a subject. We could write for days to give you an answer as SQL Server and Windows performance is a very big topic. I'd suggest you do some googling instead and read all about it. I would highly recommend purchasing a book as well.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -