Solved

Calucating IOPS - Whats tools do people use on Windows 2003 Sp1/SQL Server 2000.

Posted on 2006-06-16
4
678 Views
Last Modified: 2012-08-13
I have a Windows 2003 SP1 server running SQL Server 2000 Enterprise w/ SP4. I have been tasked with calcultating:

1. The current IOPS used by our server at peak periods.

2. The maximum IOPS the installed 16 drive array can reach.

This is to help us determine what to purchase as replacement server hardware.

The vendors we are dealing with are asking for IOPS.

I have tried to use IOmeter to determine the array speed but it uses port 1066 which conflicts with LSASS on our server and it will not launch.  There seems to be no easy way to change the port it uses.

Anyone been down this road? What tools have you used?

Thanks.
0
Comment
Question by:Primedius
  • 2
4 Comments
 
LVL 7

Expert Comment

by:TRACEYMARY
Comment Utility
What is IOPS ?
0
 

Accepted Solution

by:
Primedius earned 0 total points
Comment Utility

Ok, I found a patch which allows IOMeter to change ports. Problem solved.
0
 

Author Comment

by:Primedius
Comment Utility
How do I close this question without awarding points?
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now