Solved

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

Posted on 2006-06-16
4
721 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 7

Expert Comment

by:TRACEYMARY
ID: 16926862
What is IOPS ?
0
 

Accepted Solution

by:
Primedius earned 0 total points
ID: 16963912

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

Author Comment

by:Primedius
ID: 16963917
How do I close this question without awarding points?
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
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…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

710 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