473,324 Members | 2,246 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Why the performace differs?

MAG
All,
I have a problem regarding SQL Server 2000 SP3,
I have SP that calls other SP and it inserts about 30,000 records as a
time,
in the development environment (MS Windows 2003 Enterprise, 256 RAM,
3.0 GHz Intel Processor) takes about 6 seconds to run this SP.

But, with the same Software but, 2.6 GHz Intel and 1 GB Ram, it runs
very slow it takes more than 135 Seconds to run,

I have read a lot of articles about expanding the SQL Memory and give
it a higher process privilege but, with no use,

I don't know where the problem is, do you have any idea about what is
the problem?

Thank you in advance,

MAG

Aug 30 '05 #1
11 1443

Please check the other processess that are running on the system.
Just execute the task manager and see what is utilizing that memory.
best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---------------------------------------

*** Sent via Developersdex http://www.developersdex.com ***
Aug 30 '05 #2
Yes, SQL Server is having the highest piority and consumes about 800MB
from the memory (I made this by configure the SQL Server from the
Enterprise Manager)

but still very slow.
*** Sent via Developersdex http://www.developersdex.com ***
Aug 30 '05 #3

"Mohamed Gad" <mo*********@gmail.com> wrote in message
news:YP************@news.uswest.net...
Yes, SQL Server is having the highest piority and consumes about 800MB
from the memory (I made this by configure the SQL Server from the
Enterprise Manager)
Does one have logging enabled and the other doesn't?

What about the disk subsystem?

That's most likely the chokepoint.


but still very slow.
*** Sent via Developersdex http://www.developersdex.com ***

Aug 30 '05 #4

Does one have logging enabled and the other doesn't?
How would i know weather the Logging is enabled or not?
What about the disk subsystem?

I don't get it.. do you mean the
FAT Type if so? Both are NTFS Partitions

Thank you soo much for your reply, but, I hope i would find a solution.
*** Sent via Developersdex http://www.developersdex.com ***
Aug 30 '05 #5
AK
many possibilities. For instance, there could be lock contention with
another connection in production

Aug 30 '05 #6
No, this database is accessed by only me no one is using it.
really, this slow performance is really weared,
I have tested it and when i run the Stored Procedure the sql server
process is eating up to 98% from the processor,

and the Stored Procedure inserts something like that
INSERT INTO CardStatus
(SrlNo, StatusID,StatusDate, PresentStatus,[TimeStamp])
Values
(@SRL, 0,GetDate(),0,GetDate())

set @CurrstatID = (select IDENT_CURRENT('CardStatus'))

/*Card Loc*/
Insert into CardLoc
(SrlNo, LocID, TransferDate, TransID, [TimeStamp])
Values
(@SRL, 0, GetDate(), @TransID,GetDate())

set @CurrlocID = (select IDENT_CURRENT('CardLoc'))

/*Card Main*/
INSERT INTO dbo.CardMain
(
SrlNo, CTypeID, [TimeStamp], CardStatusID, CartonNo, BoxNo,
PacketNo,LocID
)
Values
(
@SRL,Cast(Substring(@SRL,1,1) AS bigint), GETDATE(),@CurrstatID,
Cast(substring(@Carton,2,3) as varchar), Cast(Substring(@Box,5,2)
as varchar), Cast(Substring(@Packet,5,2) as varchar),@CurrlocID
)

which in a loop of 10,000 time,
if you need more details, I can send them to you,

Thanks

*** Sent via Developersdex http://www.developersdex.com ***
Aug 30 '05 #7
MAG (mo*********@gmail.com) writes:
I have a problem regarding SQL Server 2000 SP3,
I have SP that calls other SP and it inserts about 30,000 records as a
time,
in the development environment (MS Windows 2003 Enterprise, 256 RAM,
3.0 GHz Intel Processor) takes about 6 seconds to run this SP.

But, with the same Software but, 2.6 GHz Intel and 1 GB Ram, it runs
very slow it takes more than 135 Seconds to run,


Are the tables the same size on both machines?

What does DBCC SHOWCONTIG say for the tables on the two machines? That is,
one could have severe fragmentation.

Are indexes the same?

And - most of all - are there any triggers on the tables in either server?

Also, I noted from your other post that you are using IDENT_CURRENT. Note
that this function is not safe for concurrent use. (Yeah, I noticed that
did not have concurrent access to your database, but nevertheless.)

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Aug 30 '05 #8
Dear Erland,
the database are the same, I made a backup from the developement one and
restored it to the Test one,

so, it should be all the same,
I don't know what's going wrong, but, I'll do some Monitoring for some
counters and I'll share the results with you, maybe we could reach
somewhere.
Hopefully,

Thanks,

*** Sent via Developersdex http://www.developersdex.com ***
Aug 31 '05 #9

"Mohamed Gad" <mo*********@gmail.com> wrote in message
news:7R*****************@news.uswest.net...

Does one have logging enabled and the other doesn't?
How would i know weather the Logging is enabled or not?


Go into Enterprise manager and check the properties of the DB.

It should be FULL, Bulk Logged or Simple.



What about the disk subsystem? I don't get it.. do you mean the
FAT Type if so? Both are NTFS Partitions


No, I mean the layout and type of disks.

RAID vs non-RAID (and type of RAID).

ATA vs SATA vs SCSI etc.

Log files on same physical drive(s) as data files. Location of temp db?

Thank you soo much for your reply, but, I hope i would find a solution.
Well, we're trying to help.



*** Sent via Developersdex http://www.developersdex.com ***

Aug 31 '05 #10
the Recovery Option is set to FULL
and the Hard disk subsystem is ATA NTFS (ONE PARTITION) system and
non-RAID

and the Log files are on the same Partition.

*** Sent via Developersdex http://www.developersdex.com ***
Aug 31 '05 #11
Mohamed Gad (mo*********@gmail.com) writes:
the database are the same, I made a backup from the developement one and
restored it to the Test one,
Thanks. That is valuable information. It would have been a good idea
to include that originally, to avoid unnecessary speculation.
so, it should be all the same, I don't know what's going wrong, but,
I'll do some Monitoring for some counters and I'll share the results
with you, maybe we could reach somewhere.


Did you ever post the queries and the query plans?

It's difficult to give good advice with so little information. I would
definitely look into setting up a second instance on the dev box, and
install SP4 on it, to see whether the service pack is part of the equation.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Aug 31 '05 #12

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Tobias Erbsland | last post by:
Hello I have a problem with an error message. I created a new class (as OpenSSL helper): class DataBlock { public: DataBlock(); DataBlock( unsigned int size );
10
by: blimeyoreilly | last post by:
Hi I've a small problem .. can anyone figure it out? I am working in VS.NET in C++ with MFC. I have a CWinApp-based class called CTestHarnessApp. I keep getting the 'differs in levels of...
6
by: Bern McCarty | last post by:
I'm trying to use the VS 2005 March Tech Preview and am trying to adjust some MC++ to the new C++/CLI syntax. I got a little hung up when I encountered the below error. Certainly my...
0
by: Liorm | last post by:
Hi, I found URLEncode differs in ASP and ASP.NET - when I encode "-" in ASP it gives me %2D, and in ASP.NET it gives me "-". Why? Does it happen with other characters? And how can I get the...
19
by: Tony Johansson | last post by:
Hello!! Which have best performance between i++ or ++i. Is it exact the same or is it some very small difference in performace betwwwn these two. //Tony
6
by: Angus | last post by:
I am using a global which is a void* I have it defined in one file as: void* hFlag; and one other header file as: extern void* hFlag; But I get this compile error:
8
by: asd | last post by:
Hello all. I was doing some kind of development and in the test file I have something like this: ///// Test File ///// double x = sin(45); The output for that statement is:
16
by: Josef Dalcolmo | last post by:
I tried this on Windows only: In Python 2.4 os.path.getmtime returned the local time, in Python 2.5 it seems to return GMT: import os, time print ctime.time(os.path.getmtime(foo)) differs...
7
by: Peted | last post by:
Hi, im hoping someone cane provide or point to a definitive accurate explantion of dotnet compilation when run and the best way to optimise peformace when dotnet code is run first time and...
3
by: imaloner | last post by:
I am posting two threads because I have two different problems, but both have the same background information. Common Background Information: I am trying to rebuild code for a working,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.