var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Development Vs Enterprise | Performance
We're trying to work out why the same SQL Script takes much longer to run within the Enterprise environment compared to the Development?
What makes matters worse is the development version is on a standard desktop (P4 1.8 256MB RAM) compared to the Enterprise version which sits on a dual Xeon with 1Gig of RAM.
Is is related to the SQL product or am I missing something here?
What level of user activity is occuring on your "Enterprise" (I assume you mean "Production") environment?
What does the script do? Heavy inserts/updates/deletes? These could all be affected by other users accessing the same data tables simultaneously.
Does indexing match between the two systems?
Have you run UPDATE STATISTICS on your production environment?
Are the two databases the same size?
Lots of things that could cause this...
I'm trying to work out why our SQL production server is so slow.
Using Select statements everything is fine but using an Insert statement causes immense slow down.
I created a new database in each of the environments listed below then ran a test script via Query Analyser.
The Desktop running the development edition took just over 1 minute, the server - running the full production app - took nearly 7 minutes.
The script is basic and simply created a table then inserts 100,000 records - I've copied the script below.
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Test_Table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Test_Table]
CREATE TABLE [dbo].[Test_Table] (
[ID] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
DECLARE @i int
INSERT INTO Test_Table values (@i)
You have to make the tests with the same load on both servers, that's the only way to get a value that you can compare between those two...
There's zero load on either machine as I perform these tests.
Using Task Manager I monitored CPU and Memory usage which remains at a minimum.
Well and truly stuck here. Do you think is could be a configuration issue in SQL? I've checked and both machines are running Service Pack 3a.
Does the developer edition process differently compared to the full Enterprise/Production Edition?
So you have put the production server "offline" during testing?
Originally Posted by
...and you are 100% sure that nobody is accessing the server during the performance test!?
I don't think that there should be big differences, and if there were they should be the other way round...
Originally Posted by
We have resolved this issue - thanks to all those who helped.
The production servers are RAID enabled, and we've had to fit a battery to enable write caching. So ultimatley is was an I/O issue but hardware related.