SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 SQL Server standard on SCSI drives
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pvrk
Starting Member

1 Posts

Posted - 07/01/2013 :  14:53:42  Show Profile  Reply with Quote
We have an sql server application. It is working fine with regular hard disks. One client provided SCSI drives, and all data insert/update operations are taking lot of time. Here are some stats i have collected, can some one please tell me what could be the issue?

wait_type Avg Wait in ms
LAZYWRITER_SLEEP 541

SQLTRACE_INCREMENTAL_FLUSH_SLEEP 3993
REQUEST_FOR_DEADLOCK_SEARCH 4983
XE_TIMER_EVENT 28353
FT_IFTS_SCHEDULER_IDLE_WAIT 56677
LOGMGR_QUEUE 121
BROKER_TO_FLUSH 1027
SLEEP_TASK 338
CHECKPOINT_QUEUE 6136
BROKER_TASK_STOP 10008
WRITELOG 9
SLEEP_BPOOL_FLUSH 10
PAGEIOLATCH_SH 2
IO_COMPLETION 11
SLEEP_DBSTARTUP 106
WRITE_COMPLETION 24
PREEMPTIVE_OS_FILEOPS 35
ASYNC_IO_COMPLETION 1596
PAGEIOLATCH_EX 5
PAGEIOLATCH_UP 20
CHKPT 697
SLEEP_SYSTEMTASK 694
PREEMPTIVE_OS_WRITEFILEGATHER 49
PREEMPTIVE_OS_CRYPTIMPORTKEY 1
LATCH_EX 414
LOGBUFFER 5
PREEMPTIVE_OS_CRYPTOPS 189
SQLTRACE_FILE_BUFFER 32
PREEMPTIVE_OS_LIBRARYOPS 202
PREEMPTIVE_OS_GENERICOPS 10
IMPPROV_IOWAIT 4
PREEMPTIVE_OS_FLUSHFILEBUFFERS 31
FT_IFTSHC_MUTEX 158
PREEMPTIVE_OS_SETFILEVALIDDATA 34
MSQL_XP 1
PREEMPTIVE_OS_PIPEOPS 113
ASYNC_NETWORK_IO 0
PREEMPTIVE_OS_WAITFORSINGLEOBJECT 0
PREEMPTIVE_OS_GETPROCADDRESS 1
LCK_M_U 51
BROKER_EVENTHANDLER 13
PREEMPTIVE_OS_AUTHENTICATIONOPS 0
PREEMPTIVE_OS_COMOPS 32
PREEMPTIVE_OS_REPORTEVENT 0
PREEMPTIVE_OS_LOOKUPACCOUNTSID 0
PREEMPTIVE_OS_LOADLIBRARY 7
PREEMPTIVE_OS_QUERYREGISTRY 1
SLEEP_DCOMSTARTUP 15

tkizer
Almighty SQL Goddess

USA
36594 Posts

Posted - 07/02/2013 :  18:07:50  Show Profile  Visit tkizer's Homepage  Reply with Quote
What does average disk/sec reads and writes show in PerfMon?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2004 Posts

Posted - 07/06/2013 :  04:11:34  Show Profile  Visit jackv's Homepage  Reply with Quote
if you think disk latency is slowing down the user response time - use the queries\methods here to identify hotspots - http://www.sqlserver-dba.com/2012/11/sql-server-how-to-check-disk-latency.html
It is difficult to identify where queing could be occuring

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000