Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andy.pere
Starting Member
8 Posts |
 Posted - 2009-07-21 : 13:02:13
|
Hey everybody.I´m freaking out  . I have a sql 2005 server, which works fines, except that is VERY slow compared to another servers we have here in the company.I don´t even know where to start. Any help will be much appreciated.I have done a simple .exe unit test, that creates a table, insert 100 rows in it, and drops the table.In a very similar machine(hardware), all of this runs in 60-100 miliseconds.In the problematic server, it takes about 600-2000 miliseconds.It´s a lot of time, since i need to import about 500.000 rows two times a day.What i´ve done so far.- Installed the latest sql and windows server patches.- Reinstalled SQL server- Changed DataBase.- Used a Hard Disk benchmark, which had the same result in the good server.- Hitted my head over the wall  Thanks a lot!Lil Crappie Programmer |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-07-21 : 13:14:47
|
| Use SQL Profiler on the running SQL code in both servers. post output here.Is Cache/ good/bad Execution plans at play?Is a firewall/antivirus software difference at play?Is a Network card setting different at play?Are both servers in the same location? Are both clients on the same network settings?Is the code being executed/called from the same client? |
 |
|
|
andy.pere
Starting Member
8 Posts |
Posted - 2009-07-21 : 13:29:34
|
| Hey There!Both traces are here [url]http://www.datamotion.com.br/Traces.rar[/url]I´m kind of a nwebie. Dind´t understand about Cache.There´s No firewall or antivirus on the play.No network card different.Both servers are on the same network. The applicaiton that makes the test runs locally. So, there´s no network traffic.Thanks =)Lil Crappie Programmer |
|
|
|
andy.pere
Starting Member
8 Posts |
Posted - 2009-07-21 : 14:19:27
|
| Anyone?Lil Crappie Programmer |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-21 : 14:56:31
|
You are planning to import 500k records with an application, instead of using BCP or BULK INSERT?
N 56°04'39.26"E 12°55'05.63" |
|
|
|
andy.pere
Starting Member
8 Posts |
Posted - 2009-07-21 : 15:01:47
|
| Yes, and in the another server it runs in less than 3 minutes.I cannot use bulk or another things because there´s a Interop dll used to cleansing and standarlization.Anyway, the problem is the server.Lil Crappie Programmer |
|
|
|
andy.pere
Starting Member
8 Posts |
Posted - 2009-07-21 : 15:25:46
|
| Ok, I will format the server tomorrow.Hope this helps =(Lil Crappie Programmer |
|
|
|
DKidd
Starting Member
4 Posts |
Posted - 2009-07-22 : 17:19:49
|
| You say the machines are roughly equal but I wonder if there may be some minor difference that is causing the problem.How much RAM do you have on the slow machine vs how much on the good machine and what type/speed is it? Its also possible that one of your RAM sticks is starting to go bad, check available resources on the machines using Task Manager and Perfomance Data especially the Totals and look at total number of threads running on each machine. Also look at the Cache Amout and Kernel available memory. If the RAM is the same bewteen the two, these numbers should also be similar.Also, Hard Drives - is it writing direct to a hard drive or is it using a RAID setup? If direct to hard drive, compare the two speeds of the hard drives. Also the speed of the motherboard bus between the two machines.The next thing to look at is what besides SQL Server is running on each of these machines and using system resources. One other thing, on the Bad Trace, you had an Audit Logout between each insert but the on the Good Trace you didn't. I'm not sure it would be make any difference but it was the most glaring difference between the two tests. |
|
|
|
|
|
|
|
|
Slow Perfomance (really slow)