Gathering Baseline Statistics

  • Hi

    I just listened to Brent Ozar's video on this and the video is from 2009 so not sure if there are new ideas. I also looked into Allen White's, 'Maintain SQL Server Performance Baseline with Powershell'. I have been in my position as DBA for 6 months. I would like to begin gathering baseline statistics for each server. Would you share links or ways that you gather these statistics?

    Thanks

    Kathy

  • Yes, there are many articles on capturing stats in sql server.

    Take a look at this one http://www.sqlservercentral.com/articles/baselines/96270/

    You can overview some more here: http://www.sqlservercentral.com/Search/?q=statistics&s=0&t=a&sort=relevance

    Igor Micev,My blog: www.igormicev.com

  • I have my database, jobs and stored procedures setup to collect and store baseline statistics on server A. I am now trying to figure out how to gather data from other non-linked servers (B,C,D...) and write this collected data to the database on the server A. Would someone share with me how this is done? Do I have to write to a flat file on servers B, C, D.. and run an SSIS to load the data into the database on server A?

    Thanks

    Kathy

  • You can do it directly with SSIS.

    Igor Micev,My blog: www.igormicev.com

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply