SQL Server - Help needed
Posted on 2011-05-12
We have 6 sql instances on a server, I am asked to study the existing usage of memory, cpu, disk space etc. I don't have rdp access to this server. What's the best way I can accomplish this task?
Here's some information about these instances.
1. We have a lot of user databases on these 6 instances( about 80 databases in 6 instances together with sizes ranging from a few MB to 60 GB ). There's a nightly job that runs for full backups of these user dbs everyday (all the dbs are in simple recovery mode).
2. In 2 instances we have transactional replication.
3. All these instances are used for development and testing purposes by 6 to 8 app & testing teams.
4. All the instances are: Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)
I need to come up with a strategy for managing backups to reduce the disk space usage. I am thinking of a weekly once fullbackup and a differential backup everyday. any other ideas?
How can I best study the current usage of memory, cpu and related details for these 6 instances with out having access to this server? I could have run performance monitor if I had access to this server, is there a way we can run performance monitor remotely on this server? Any other ideas?
If it's absolutely necessary, we are thinking to migrate 2 instances (non- replication instances) to a new server and that would be based on my inputs.
I am looking for help to accomplish this task. I hope I have provided some kind of useful information to help me on this, please let me know for any additional information. Thanks.