Hi. Anyone hear of any software pakages out there that will monitor SQL server instances and databases to predict when capacities will go over limits? Not just alarm monitoring like for a service dropping out, but something that will graph and/or predict when space will go over a limit, an important index will frag, things like that. I know Quest has a capacity planner that can do this for disk,fragmentation and datafiles, but does anyone know of competing products? Thanks! Rich
Welcome to the forums. Do you have any indication from your business in this regard? Before you can start planning the hardware for a system, you need to determine a realistic set of requirements. These requirements should detail the expected number of users (at peak and on average), the usage profile for the system, desired response time for certain activities, and other factors such as the maximum CPU usage you wish to see on your servers. The exact list of requirements will vary depending on the type of system you are creating, but you can get an idea of what is needed by looking at the appropriate capacity planning tool(s) in this website under software spotlight section.
