thanks for your reply,

memory is 16GB

here is problem wait stats is more .

Pls find the attachment

please suggest can we run

DBCC SQLPERF("sys.dm_os_wait_stats",CLEAR); in production hour

or

what is the best solution to clear the wait stats

thanks for your replies.

yes , i executed sys.dm_os_wait_stats and found the following has high wait time

CXPACKET

LAZYWRITER_SLEEP

SQLTRACE_BUFFER_FLUSH

SOS_SCHEDULER_YIELD

how to clear these wait types

thanks

Hi Lynn,

thanks for ur reply.

yes, i am having the space issue, thats y i truncated some records.

Now the backup file size(30gb) becomes as expected. but the DB (.mdf file) size...

hi bhuvnesh,

Please look into last line.

[SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'Metrics', file 'Metrics_log' on file 1. [SQLSTATE ... The step failed.

TIME :20100512:2015

I got failure...