SQL Server Performance Forum – Threads Archive
Hardware ConfigurationHi, We have an existing setup of our Co-Lo as follows: EqualLogic PS300E iSCSI SAN with 2 arrays grouped together. Each Array has 14 SATA Disks with 6.5TB capacity and is configured with RAID50. We are moving our existing SQL 2000 dbs to this new location and soon will have SQL 2005 installed. Our largest db is around 12GB. It is more read intensive. Before we move any of the SQL Server dbs over, I would like to test the existing hardware and was wondering if I could get help with some proper procedure in doing so?? I have ran SQLIOSim on our existing hardware and if this is the correct tool to go with at this new location?? Thanks.
Check: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=16995 Luis Martin
SQL-Server-Performance.com All in Love is Fair
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
Did you get any informaton from SQLIOSIM tool results?
As you are going on upgrade path make sure to consider the changes between the 2 versions, backward compatibility, stored procedure optimization and selection of DTS packages to SSIS including the scheduled jobs. Once you have identified the upgrade path, then it will be easy to go through the hardware performance tuning. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.