December 26, 2008 at 3:38 am
MISCELLANEOUS5199.00.00.0
LCK_M_SCH_S5.029969.00.0
LCK_M_SCH_M2.01765.00.0
LCK_M_S201.0604815.0234.0
LCK_M_U 0.00.0 0.0
LCK_M_X970.0415880.0108.0
LCK_M_IS17.0313077.00.0
LCK_M_IU0.00.00.0
LCK_M_IX10.0113266.00.0
LCK_M_SIU0.00.00.0
LCK_M_SIX0.00.00.0
LCK_M_UIX0.00.00.0
LCK_M_BU0.00.00.0
LCK_M_RS_S0.00.00.0
LCK_M_RS_U0.00.00.0
LCK_M_RIn_NL0.00.00.0
LCK_M_RIn_S0.00.00.0
LCK_M_RIn_U0.00.00.0
LCK_M_RIn_X0.00.00.0
LCK_M_RX_S0.00.00.0
LCK_M_RX_U0.00.00.0
LCK_M_RX_X0.00.00.0
SLEEP1465876.01.2366604E+91.1830881E+9
IO_COMPLETION255869.01586858.0885.0
ASYNC_IO_COMPLETION32.0189.00.0
RESOURCE_SEMAPHORE0.00.00.0
DTC0.00.00.0
OLEDB1342360.02.5250015E+99.1261798E+8
FAILPOINT0.00.00.0
RESOURCE_QUEUE1710275.03.7076291E+91.2362086E+9
ASYNC_DISKPOOL_LOCK563.00.00.0
UMS_THREAD0.00.00.0
PIPELINE_INDEX_STAT34.00.00.0
PIPELINE_LOG0.00.00.0
PIPELINE_VLM0.00.00.0
WRITELOG745526.0878464.012195.0
PSS_CHILD0.00.00.0
EXCHANGE2424.051693.0203.0
XCB0.00.00.0
DBTABLE11.026000.00.0
EC0.00.00.0
TEMPOBJ0.00.00.0
XACTLOCKINFO0.00.00.0
LOGMGR0.00.00.0
CMEMTHREAD33214.0328.0234.0
CXPACKET349584.01.0981204E+890348.0
PAGESUPP120.00.00.0
SHUTDOWN0.00.00.0
WAITFOR0.00.00.0
CURSOR0.00.00.0
EXECSYNC2.00.00.0
LATCH_NL0.00.00.0
LATCH_KP0.00.00.0
LATCH_SH248.01734.016.0
LATCH_UP120.023722.00.0
LATCH_EX748653.01896753.036648.0
LATCH_DT0.00.00.0
PAGELATCH_NL0.00.00.0
PAGELATCH_KP0.00.00.0
PAGELATCH_SH50625.013881.09610.0
PAGELATCH_UP38427.018914.0623.0
PAGELATCH_EX1966.0530.0109.0
PAGELATCH_DT0.00.00.0
PAGEIOLATCH_NL0.00.00.0
PAGEIOLATCH_KP0.00.00.0
PAGEIOLATCH_SH1.535972E+73.2361248E+8222512.0
PAGEIOLATCH_UP20590.0457453.01530.0
PAGEIOLATCH_EX69767.0767213.0800.0
PAGEIOLATCH_DT0.00.00.0
TRAN_MARK_NL0.00.00.0
TRAN_MARK_KP0.00.00.0
TRAN_MARK_SH0.00.00.0
TRAN_MARK_UP0.00.00.0
TRAN_MARK_EX0.00.00.0
TRAN_MARK_DT0.00.00.0
NETWORKIO249506.01103821.00.0
Total2.2451916E+77.9110216E+93.3322908E+9
one of the production server was getting low performance, can you tell me, what actual bad signal wait time on resource? and for performace what i should check?
thanks
December 26, 2008 at 4:52 pm
What is the sql server version, memory configuration, OS and CPU utilization?
MJ
December 26, 2008 at 8:55 pm
hi manu thanks for reply....
RAM - 4GB
OS- windows server 2003 enterprise edtion
CPU - Intel Pentium 4 CPU
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply