Microsoft

SQL Server Health Report

Yesterday I posted about a great article that I found on how to use Powershell to create an excel file and also use SMO to get information about SQL Server. I am working on a report that I will have run daily. This report is going to give me an overall health check of my SQL Servers. I am going to have it report to me if all of my important jobs are set up and running properly, These jobs being things like backups, tranlog backups (if the Database is using the Full Recovery Model), Rebuild indexes, and things like that. it will tell me how big each Database is, where the MDF and LDF files are on the filesystem, How much drive space we have available for those databases on the filesystem, how much space allocated to the DB is Free, and finally, for instances that have mirroring set up it will tell me the state of the mirror.

For the servers that I am working with on this report I feel that this really does give me a good health check of the server. I am sure that as time goes on I will add more and perhaps modify this to output as a web page and then put some nice eye candy on it for things like cache hit ratio and other metrics like that. I will be posting the code for this report when I am complete with it.

Microsoft Live Mesh

So, I do not know about you allI can say that since I know something about computers I get hit up for free computer help from family all the time. I do not really mind this but it is sometimes hard to get to them in a timely manner. Well I stumbled upon Microsft Live Mesh the other day and it is pretty cool. Here is a link so you can check it out.

 https://www.mesh.com/welcome/default.asp…

This gives you 5GB of space on a virtual desktop so that you can synch and share files between computers, and it will let you remote a computer while letting the people on the other end watch, or you can hide it from them. I have used this a couple times and I like it. It is still in Beta so take it with a grain of salt. I hope that it gets better but I really love the Idea. Before I found this I was tempted to sign up for another pay service to do remoting. All you need for this is a Windows Live ID.

Let me know what you think about it.