SQL Server Performance

Capacity Planning with SQL Server

Discussion in 'Third Party Tools' started by bbRichbb, Jul 24, 2009.

  1. bbRichbb New Member

    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
  2. Luis Martin Moderator

    Take a look of Diagnostic Manager from Idera.
  3. wayen.zjw New Member

    maybe SQL diagnostic manager is a good one you should give it a try
  4. satya Moderator

    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.

Share This Page