Re: SQL Server 50% slower running on SAN

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 18:38:53 -0500

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: Active/Active clustering
    ... The OS and the SQL Server executables gets installed on the local drive. ... Data and Quorum go on the SAN. ... >> For clustering, you need shared storage. ... >> Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: EVA defragmentation.
    ... Mike Epprecht, Microsoft SQL Server MVP ... > Does the built-in defragment utility for Win 2003 work on the SAN (Raid ... >> Mike Epprecht, Microsoft SQL Server MVP ... >>> Are you saying that for certain block sizes a regular defragment (such ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 50% slower running on SAN
    ... than 3 hours when writing to the SAN. ... What takes 3 hours on the SAN is accomplished ... Network Interface counter is very low for SQL Server ... Burkhard ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... Our san guy is ... completely forget about is that moving the head on the disk is the slowest ... the drives that were being assigned to the SQL machine. ... I mean the binn folder which contains the sql server executable among ...
    (microsoft.public.sqlserver.setup)
  • Re: Disaster recovery
    ... I'm not familiar with REDO groups. ... use the SAN replication functionality to replicate the SQL Server data. ... "tram" wrote in message ...
    (microsoft.public.sqlserver.server)