Monitorizarea mai multor Servere Sql 2008

 

Ce monitorizam

• Backup

• Spatiu liber

• Job-uri

• Mai multe amanunte aici

http://www.sqlservercentral.com/articles/Database+Administration/62480/

http://www.sqlservercentral.com/articles/On-Call+Duties/64426/

 

Metoda cea mai rapida

 

• Multi server results

http://blogs.msdn.com/sqlrem/archive/2008/02/04/multiple-server-query-execution-in-sql-server-2008.aspx

• Demo

Metoda cea mai in voga

• Powershell pentru Visual Studio 2008

• Demo

script:

invoke-Sqlcmd "EXECUTE master..xp_fixeddrives" -database master -serverinstance . | out-File  andrei1.csv
invoke-Sqlcmd "EXECUTE master..xp_fixeddrives" -database master -serverinstance .\sqlexpress | out-File  -append andrei1.csv

Metoda cea mai sigura

• Data Collection

http://technet.microsoft.com/en-us/library/bb677180.aspx

• http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-performance-data-collector/

Metoda proprie – cea mai usor configurabila

• Proiect propriu sql consolidate

http://sqlconsolidate.codeplex.com/

• Demo

Posted in sql

One thought on “Monitorizarea mai multor Servere Sql 2008

Leave a Reply

Your email address will not be published. Required fields are marked *