Re: SQL Server 50% slower running on SAN

From: Burkhard (bmeier_at_infogenesis.com)
Date: 03/01/05 

Date: Mon, 28 Feb 2005 16:21:57 -0800

Hello Adam,

Yes, SQL Server is cranking at 100% CPU usage for more
than 3 hours when writing to the SAN. It is also using up
to 100% when writing to the local drive, but it is just
much faster. What takes 3 hours on the SAN is accomplished
in 1.5 hours writing locally.
We do notice in perfmon that the Bytes Total/sec for the
Network Interface counter is very low for SQL Server
processing compared to performing a file copy/transfer.
SQL Server only writes Avg: 13,000 , Max: 28,308 bytes per
sec, while a file transfer gives us Avg: 10,000,000 , Max:
36,769,205.
Note: We just found out that the .exe that is writing to
SQL Server was a version which has been hot fixed in the
meantime. This version had unnecessary excessive logging
to the Windows Event log. Running the hot fixed .exe that
does not do this writing to the Event log now gives us
much better performance and our problem seems to be solved.

Thanks for your quick reply.

Burkhard

>-----Original Message-----
>Have you used perfmon to find out where the bottleneck is?
>
>
>--
>Adam Machanic
>SQL Server MVP
>http://www.sqljunkies.com/weblog/amachanic
>--
>
>
>"Burkhard" <bmeier@infogenesis.com> wrote in message
>news:2b2601c51dec$c2d73be0$a601280a@phx.gbl...
>> We are in the final tests of running SQL Server on the
SAN
>> we are about to deploy to our data center. During QA
>> testing we are noticing a 50% increase in processing
speed
>> even though the SAN seems to be configured correctly.
>> Any idea where to look further would be appreciated.
>>
>> Thanks,
>> Burkhard
>> QA Tester
>
>
>.
>

Relevant Pages

  • Re: vb.net dataTbl can DTS read?
    ... then using ADO to read/write the data to Sql Server. ... like what DTS does with Text Files, MS Access data, etc. ... Right now I am experimenting with writing the data from ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server 50% slower running on SAN
    ... SQL Server MVP ... -- "Burkhard" wrote in message ... > We are in the final tests of running SQL Server on the SAN> we are about to deploy to our data center. ... During QA> testing we are noticing a 50% increase in processing speed> even though the SAN seems to be configured correctly. ...
    (microsoft.public.sqlserver.server)
  • Re: Control storage of Data
    ... I am aware of the facts your writing about, ... binary data" information directly from the SQL Server ... How to control that formatting depends on ... >usually determined by your Windows Control Panel settings. ...
    (microsoft.public.sqlserver.server)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, I get no problems doing this, and I push the cpu, disks etc... ... Buffalo isn't MS, I do like the direction MS are taking with software certification - driver signing, Vista/ Windows 2003 certified etc... ... The newer features are there because customers and folk in the community like me asked for them, they aren't creating features to catch up with oracle, stability is there, give it another 3 - 4 years and measure the two database products and their positions - it will be very interesting, I know I chose the correct product when I moved away from DB2 and could do oracle or SQL Server. ...
    (comp.databases.oracle.server)
  • Re: SQL Server 2000 speed problems
    ... SQL Server MVP ... > CREATE TABLE Control ... > Every second the database gets updated with a timestamp and 50 new values. ... ' Perform the actual writing to the database through the batch of SQL ...
    (microsoft.public.sqlserver.programming)