December 18, 2002 at 9:08 am
I need some information about running SQL Server 2000 on NT versus 2000. I know that Microsoft supports SQL Server running on NT. Does any know of articles showing that SQL Server 2000 runs slower on NT versus Windows 2000?
Derek
Derek
December 18, 2002 at 10:16 am
Not sure of what there is specifically for SQL, but the IO routines, memory management, overhead for perfmon, and other utilities, run much better on 2000 than NT.
Plus there is the support issue. No new patches (other than security) for NT.
Is there a reason you need a justification? Is this an upgrade?
Steve Jones
December 18, 2002 at 12:24 pm
This company that I am interviewing for wants to do replication because they said there Sql Server is slow. I think they probably have some other issues that could help speed up the applications without doing replication. Is there any good material about using the execution plan for query analyzer?
Derek
Derek
December 18, 2002 at 12:52 pm
Not anything specific. Some articles on this site that touch on it, some better than others.
If they suspect slowness, run Perf mon and look for CPU spikes, cache hit ratio low, etc.
Then run profiler and grab the T-SQL and RPC completed events. Look for high reads. Once you have these, then look at these in QA with SET STATISTOCS IO ON and SET STATISTICS PROFILE ON. See if you are getting physical reads.
All this can point you along. Before you spend too much money, invest in Brian Kelly's Perf Tuning book and see what your problem is, then you can look at hardware or software changes.
I'm sure 2000 would give you a boost, but the $800 plus the time might not help if hardware or the app is the problem and you might look bad. A couple days tuning might help point you along.
http://www.sqlservercentral.com/columnists/bkelley/perfmonexcerpt.asp
Steve Jones
December 18, 2002 at 1:03 pm
Thank you, I have bought that book, and it is an excellent book for getting started with monitoring. That should help me
Derek
Derek
December 18, 2002 at 1:19 pm
Let us know how it goes. Be interested to hear if you do get some good results either on the app or looking at NT v 2K.
Steve Jones
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply