Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 SQL Server standard on SCSI drives

Author  Topic 

pvrk
Starting Member

1 Post

Posted - 2013-07-01 : 14:53:42
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

38200 Posts

Posted - 2013-07-02 : 18:07:50
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
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-07-06 : 04:11:34
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
   

- Advertisement -