[SQL 2012] Ideal cluster size for transactions per minute and create database? Performance issue. |
| Ideal cluster size for transactions per minute and create database? Performance issue. Posted: 24 Mar 2013 08:51 PM PDT A number of SQL Servers here are setup with a disk cluster sizes of 4K, however for SQL Server , shouldn't it really be 64K? When I run transaction tests using HammerDB I get good results, however when I tested the performance of creating a database and extending it the results are not so good .for example: ------------------4K Cluster Size:Tpm = 1,038,994.00 CREATE DATABASE 20GB = 15.1 secondsALTER DATABASE 10GB = .34 seconds ----------------64K Cluster Size:Tpm = 1,500,965.00 CREATE DATABASE 20GB = 31.7 secondsALTER DATABASE 10GB = .34 seconds The above results are consistent for 1000 test cycles. The Transactions Per Minute show a clear performance gain, but the CREATE DATABASE statement takes twice as long, why is that? I would expect it to be fast because its writing a contiguous block? And why is the ALTER DATABASE statement the same speed regardless? |
| Posted: 24 Mar 2013 11:03 AM PDT Hi,I'm trying to attach the data file of Adventureworks. I have download the file from http://msftdbprodsamples.codeplex.com/releases/view/55330When I try to attach the file (I remove the log file because I don't have one) I receive the following error: The header for file 'C:\AdventureWorksDW2012_Data.mdf' is not a valid database file header. The FILE SIZE property is incorrect.My SQL Server version is SQL Server 2012 Developer edition with sp1Can someone help? |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment