DBA Administration difference between SQL server 2005 and 2008

Hi All,
I wish to know as a SQL server administrator what difference do you see between 2008 & 2005?

Does SQL server 2008 contains something like Oracle GRID to manage tonnes of remote databases from a single dashboard?
Oracle Grid is very similar to BMC patrol or Quest tools which monitor availability as well as performance of remote systems centrally. Email/SMS alerts could be raised when database/os/hardware threshold hits a preset limit.

Thanks
crazywolf2010Asked:
Who is Participating?
 
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
Yes, you have Policy-Based Management tool which introduces the Central Management Server. Here are some references.

http://msdn.microsoft.com/en-us/library/bb510667.aspx
http://msdn.microsoft.com/en-us/library/dd542632(v=sql.100).aspx
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
from what I know, sql 2008 does not have such tools...
0
 
crazywolf2010Author Commented:
Hi mwvisa1,
Your link  http://msdn.microsoft.com/en-us/library/dd542632(v=sql.100).aspx looks promising.

Have you worked on this tool?
Can you please explain if I have 100 SQL server databases across vmware,standalone hardware , how can I configure such tool to create a central management repository?

Thanks
0
 
Kevin CrossChief Technology OfficerCommented:
I have not moved my production systems to SQL 2008, but SQL MVP Jorge Segarra is a good resource. Go to http://sqlchicken.com/presentations/ and download his presentation on "Policy Based Management in a Nutshell" | he blogs a bit about the topic also. From my understanding, the Central Management Server can be setup easily and once you register all 100 of your servers, it definitely works. I watched Jorge live and he had groups like DEV, PROD, and QA and he was able to run policy's or SQL queries against any group of servers OR all servers right from one SSMS window.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.