SQL Server Performance Forum – Threads Archive
Huge performance gap: Windows Server vs. Desktophallo, we find a huge difference in write-performance using a MSSQL 2000 SP3 database on either a Windows 2000 Server or a Windows 2000 Desktop system. We are using only one table (t_test_small) with one column (a0: nvarchar) and the following ‘mini benchmark’ script in query analyser: ———————-
delete from t_test_small
declare @x int
set @x = 0 select getdate() while @x < 5000
insert into t_test_small(a0)
set @x = @x + 1
end select getdate()
———————— with the following results for the total running time: MSSQL 2000 SP3 on Windows 2000 Desktop: 2 seconds
MSSQL 2000 SP3 on Windows Server 2000 : 30 seconds Hardeware is quite similar on both systems (PIII 1000 MHZ, 512 MB RAM, IDE 5400 RPM hard drive). In addition we find similar results on other Windows Server 2000 systems provided by our hosting partner. It seems like this huge performance gap comes from the differnent operating system. How can this be? Any help is highly welcome. sincerely
Are the execution plans for the query exactly the same on both servers ?
i checked the execution plans for the query on both servers . They are exactly the same. still can’t believe the influence of the operating system.
Rebuild all index in server and try again.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
I dont believe the performance issues are OS related.
Try defragging your disk too. Run performance monitor and monitor common counters such as cpu usage, disk queue length, network queue etc. There must be some difference in configuration. What network libs are used to connect on both servers ?
Ping both servers, response time is satisfactory ?