Managing Hight Qty of SQL Servers By Client
-
Hi Guys,
I'm really after your opinion on managing big estates that span multiple clients.
We're having a restructure at work (Well a buyin and buyout actually) as a result we are going to inherit plenty of data and plenty of new servers, almost over night - eventually these server will be absorbed in and databases moved to new homes.
But it got me thinking.
So, I'm thinking of writing some tools to make managing this many servers (potentially more than 450 physical and virtual)
In terms of screen layout whats the best way to visually do this?
The servers would naturally group themselves into a tree like
root
... company
......environment
to make that clearer
root
... Al's Company
...... Development
...... Staging
...... Production
... Bob's Company
...... Dev
...... Test
...... Live
...... Reporting
And so forth, if you get the idea
Buying in Spotlight wont work as we have too many custom processes to take into account.
So any thoughts or diagrams are appreciated!
Cheers
Alex
-
are you familiar with SSMS's Registered Servers or Central Management servers?
it does exactly what you seem to be asking, and it's built in.
once you add them in a hierarchy, you can run a commands/query against any node in the tree , against all servers if needed by selecting the top most node.
i use it to administer 70 or so instances across 50 or so servers.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Aye, Lowell thats currently how its being done.
But for exceptions its not so easy or clear to see whats what.. I'm really looking for a high level overall that yu can then drill into to see whats broken...
Similar to Spotlight I guess but being able to pin (user defined) tasks to the interface.
im not making this clear. i'll think how to articulate this.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply