Post reply

SQL 2000 Stats

  • August 30, 2005 at 12:04 pm

    #91006

    Hello Everyone,

    I have been asked to provide some stats to one of the users of a specific SQL instances. I have a server with 8 SQL instances running on it and have been asked to provide some stats by a user of one of those instances on the other instances.

    Is there a way I can provide this info based on these specific stats:

    Statistics could include

     1.       number of simultaneous users

    2.       size of database

    3.       number of transactions per hour (broken down to inserts, updates, deletes, and selects)

    I looked at SQL Profiler, but either did not select the right data or I must be doing something wrong because the data isn't useful.

    I've also looked at perfmon, but I'm missing a few SQL specific counters from the list of available counters. I'm going to look on MS site for a resolution on that problem.

    Also, is the a recommendation on the max number of SQL instances that should run on a server? I'm sure it's based on the hardware, but in my case, the server specs are:

    8 X 20GHz XEON processors

    8 GB RAM

    350GB disk space

    Hardware array controller - RAID 5

    Thanks for your help.

  • August 30, 2005 at 12:46 pm

    #586267

    For this kind of thing I have been using a tool from Microsoft called SQLH2.  This is integrated with SQL Server Reporting Services and provides all kinds of statistics.  Other than that, here are a couple of sites I have used in the past to design profiler reports.

    http://www.windowsitlibrary.com/Content/77/15/3.html

    http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=28&rl=1

    Good Luck

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply