Thanks Jim for the Reply.

Does the Page Split counter misguiding.. How can I get the page split then for a clustered index entry.

So How can I get a perfect picture as when the page Split is occuring.

I am using perfmon to track Page Split/Sec event

As per the execution of the SQL Statements that you have provided,

1. First the From clause will be processed

2. Then WHERE clause will be processed

3. Then SELECT clause will be...

Thanks Gail for following the post.

avg disk sec/Write(0.0006) and avg disk sec/Read(0.0004) values are very less.

When we get pending records there is very less utilization of disk counters and CPU...

Database is handling avg transactions of 2500 /sec. These are lots of small transactions.

we are currently using SAN RAID10 with log file placed on separate disk.

Transactions are waiting for log...

I'm experiencing WRITELOG wait type in SQL Server.

This was the reason I wanted to understand the log buffer size, if we can increase it and can SQL Server perform better...

Thanks for your reply Gail.

Can we get the size of log buffer ?

Dear All,

The problem was resolved by stopping VSS Service and it is running fine on production server.

Hi Bhuvnesh/ Rob,

Thanks for your reply, but as I said the full backup is completed successfully.

Good One.

I also used STUFF and FOR XML to solve a problem at my workplace, but was surprised to see &

If the current date is equal to 13 then your query will give that as Friday.

IF (DATEPART(dd, @currDate) 13)

what about adding one more condition with above one

OR (DATEPART(dw, @currDate)...