DBA Administration difference between SQL server 2005 and 2008
Posted on 2011-09-12
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.