Error in SQL database.

[Former Member]

Hello,

I have problems in database, in Wait Statistics. The error appears in PAGEIOLATCH_SH, CXPACKET and WRITELOG. I think that probably is problem of the transaction log, but I don´t known. How can I solve the problem?.

Thanks in advanced.

[clas_hortien]

Hello,

which error occurs when you run dbcc sqlperf(waitstats) ? Please send us the complete message.

Can you furthermore please send us the complete output of the dbcc waitstats (if possible).

A high CXPACKET value points to a configuration setting of 'max degree of parallelism' of not 1 (0 or higher than 1). The SAP recommended value is 1. The setting can be changed on-the-fly without a SQL server restart.

Best regards

Clas Hortien