Sunday, March 11, 2012

Cumulative wait time on server replies

i've got 2 identiical db on 2 servers. the hardware config is different. i
run the same queries on these 2 servers. execution plan, statistics like
reads / writes / cpu time, etc are all the same, the only difference is the
"Cumulative wait time on server replies".
What does it mean? does it have anything to do with the hardware like
memory, paging file or even the speed of the hard disks?
thanks.SQL Books Online says :-
Cumulative amount of time the driver spent waiting for replies from the
server.
It's unlikely this has anything to do with the performance of your query.
You have identical query plans on different servers, do you have the same
volume of data..?
What does DBCC SHOWCONTIG show for the tables, are there differences in the
level of fragmentation.
Is blocking an issue on one of the servers as it's in a Production
environment and the other is Test..
HTH. Ryan
"Kitty" <Kitty@.discussions.microsoft.com> wrote in message
news:E865E508-11BD-4F5D-9568-1C1BAABB4F27@.microsoft.com...
> i've got 2 identiical db on 2 servers. the hardware config is different.
> i
> run the same queries on these 2 servers. execution plan, statistics like
> reads / writes / cpu time, etc are all the same, the only difference is
> the
> "Cumulative wait time on server replies".
> What does it mean? does it have anything to do with the hardware like
> memory, paging file or even the speed of the hard disks?
> thanks.
>

No comments:

Post a Comment