Solved

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

Posted on 2006-06-16
4
716 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
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

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…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

679 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