The most common tools which will help VARs be proactive are PerfMon and SQL Server Profiler. PerfMon can provide baselines which can be used to detect deteriorating performance and send alerts to the management team. SQL Server Profiler, in all but the standard template, will add significant load on your SQL Server, but is very useful for providing a window into the activity of your SQL Server.
There are also several tools which allow for remote RDBMs management, like MyLittleAdmin. However most remote DBAs use tools like Microsoft' Remote Desktop Connection which gives them complete access to the remote desktop, or tools like Terminal Services or Citrix MetaFrame which can host Management Tools (like SQL Server Enterprise Manager, or SQL Server Management Studio) remotely.
Dig Deeper on Database software management
Related Q&A from Hilary Cotter
SOA depicts how two services or programs can communicate with each other. Learn why SOA should catch the attention of service providers and the ... Continue Reading
Learn why Oracle VM would be chosen over Hyper-V or VMware and read an expert's recommendations for implementing Oracle VM. Continue Reading
Learn the new components of Windows XP SP3 including black hole router detection and network access protection. Compare XP SP3 features to Vista and ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.