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 |
|
seethem
Starting Member
46 Posts |
 Posted - 2007-10-23 : 19:12:41
|
| I have client tools installed on a server and I have registered our 30+ instances hosted on various servers to this one MS SQL 2005 Management Studios.Question:How can I use this set up to send an e-mail distribution list a nice monthly chat showing the sizes of the database, memory, cpu utilization of all the registered databases?Many thanks for your help !!seethem |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-23 : 19:48:34
|
| Store the servers that you support in a table on one central server. Create a .NET CLR function that can access a server and retrieve the information that you want. Then loop through your table that contains the list of servers and call the function. This is exactly the setup that I have in my production environment. Currently I am grabbing disk space information from drives and mount points. Next I will be gathering database growth information.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-10-27 : 12:00:52
|
| Thanks Tara.I have to take in Books online to understand what that .NET CLR function means?I was hoping that there was something similar to Oracle Enterprise Manager Grid Control.This web interface tool does it all. Very easy to use as well. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-27 : 14:14:19
|
| SQL Server has no built-in functionality to do what you want, so you either need to write code to do what you want, or find a software package that does it for you. .NET CLR functions are new to SQL Server 2005. It allows you run .NET code inside a database. In previous versions, we only could run T-SQL. Now we can program with .NET inside a database.The .NET capabilities come in very handy for situations like you have described. Through the .NET framework, you can get access to the memory and CPU utilization via the Performance Monitor objects. For the sizes of the databases, you can query sp_databases.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Database Performance Stats