Red Gate forums :: View topic - Check Time
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Check Time

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mustarirakos



Joined: 15 Jul 2010
Posts: 1
Location: chicago

PostPosted: Thu Jul 15, 2010 12:59 pm    Post subject: Check Time Reply with quote

At this moment I do a lot of vitalizing with VMware ESX and the first question I always get from my customers: What is the impact on a SQL-Server database on a Virtual machine compared with a Physical machine.

Using SQL-Data Generator to import 1.000.000 records in 25 tables give a nice stress on the server. Only, I canít really compare it as I canít see exact how much time it takes to finish the job. I like to suggest to supply a start and finish time so we also can use SQL Data Compare to test server speed without the need of sophisticated testing tools

I already get an possible work around from your engineers with an example using some command line commands, but I prefer to have timer functionality as part of the product itself Smile
Mike Cabolet
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
RBA



Joined: 05 Jun 2009
Posts: 148
Location: Cambridge

PostPosted: Thu Jul 15, 2010 2:52 pm    Post subject: Reply with quote

Hi Mike,

So what you'd like is a 'time elapsed' metric displayed in SQL Data Generator so you can use the product as a benchmarking tool?

You probably know this already but just in case I thought I'd mention that disk access on VMs is massively degraded if you use a virtual disk instead of mapping a physical disk directly. That'll be the biggest impact on disk performance.

I'm not sure if SDG would be the best tool to use for benchmarking as it only performs inserts. Is it strictly disk performance that you're interested in?

Regards,
_________________
Robin Anderson
Development
Red-Gate Software
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group