Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2006-06-16
4
Medium Priority
?
735 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
3 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 Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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.

876 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