| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-06-23 : 15:03:29
|
| I have a question for DBAs working on more than 100 or relatively many servers. Suppose you want some information, regarding all the servers - for e.g. service pack on all the servers, what is your approach?Beginners please don’t respond with sql to find service pack, I know how to do that!I have a brick and mortar option to get something from all the servers, I am just checking whether there are any better ways. ------------------------I think, therefore I am - Rene Descartes |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-06-23 : 15:25:32
|
| Thank you, Tara!I have heard that there is going to be a centralized monitoring tool in 2008. I am not sure how far it is true. I am not a CLR fan, difficult for a DBA to write CLR code. Linked server I believe is good, when permanent connection is required to the destination. Writing a batch looks interesting to me, I am doing something as below1. SSMS2. Query Editor3. Query -> SQLCOMD mode4. Ctrl + T5. execute code for. e.g. :connect server1 SELECT @@servername, serverproperty('productlevel') GO :connect server2 SELECT @@servername, serverproperty('productlevel') GO :connect server3 SELECT @@servername, serverproperty('productlevel') GO ------------------------I think, therefore I am - Rene Descartes |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-23 : 15:45:35
|
quote:
Originally posted by ravilobo
I am not a CLR fan, difficult for a DBA to write CLR code.
A DBA should start getting familiar with writing CLR objects. We don't have to be able to write complex .NET code, however we should have a basic understanding of it and also be able to read and write basic .NET code. You should consider writing this "SELECT @@VERSION" issue as a CLR since it's probably the easiest CLR to write. Here's an example of one that I wrote to get you started:http://weblogs.sqlteam.com/tarad/archive/2007/12/18/60435.aspxI'm certainly not a great C# developer as can be seen by my lack of error handling in the code, but I know enough to get by. I started my .NET education with VB.NET. I did the disk space CLR as an exercise for C#.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-06-23 : 15:58:03
|
| I checked your code, it is Greek to me!Believe me it is complex. I am done with my coding life! That is the one reason I became a DBA. Don’t want to venture there again. been there done that! no more God, please…Can you really teach new tricks to old dogs or old DBAs?------------------------I think, therefore I am - Rene Descartes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-23 : 15:59:50
|
quote:
Originally posted by ravilobo
Can you really teach new tricks to old dogs or old DBAs?
Yes. It's imperative that we keep our skill sets up to date.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-06-23 : 16:09:20
|
quote:
Yes. It's imperative that we keep our skill sets up to date.
Sometime I forget, I am really talking to the Goddess!You are right, I may have to learn CLR sometime in future, looks like it is inevitable, it’s a difficult life..------------------------I think, therefore I am - Rene Descartes |
|
|
|
contrari4n
Starting Member
27 Posts |
Posted - 2008-06-24 : 08:12:55
|
| Not sure if this is what you are looking for, but I use an HTA script for the purpose.I've described it here http://www.sql-server-pro.com/sql-server-audit-script.htmlI just copied and pasted my code into the web page so if you find any errors or have trouble using it I would be grateful if you could let me know.It takes a bit of time creating the xml file of all servers and instances but it is well worth the effort.Richard Fryarhttp://www.sql-server-pro.comSQL Server Articles and Tips |
|
|
|
|
Working with more than 100 servers