Viewing 10 posts - 61 through 70 (of 70 total)
Thanks, I'll research the fix further. Maybe it is an answer to my problems.
March 15, 2007 at 9:31 am
I did update statistics right after it happened. Also checked index fragmentation and defrag what ever was necessary. But it still happens.
The auto update statistics is off.
March 12, 2007 at 6:28 am
Yes, we did run profiler. It shows the usual stuff that we see on a normal day too.
March 9, 2007 at 2:17 pm
Sp_who2 does not indicate anything. We do see normal connections from the web server. We did think of the anti-virus so we shut it off for the time being, but...
March 9, 2007 at 6:40 am
I think I miscommunicated. What I really meant was: is it possible to create a true failover of the witness. In other words if witness1 fails, then the mirror is watched...
January 12, 2007 at 1:22 pm
Thanks for the tip. Setting up an alias helped. However I have one more problem with a witness server, which is sitting on SQL 05 Standard. I think the problem...
September 18, 2006 at 2:54 pm
One of the servers is much faster, the one where queries run for about a second. The file copy on that one takes couple of minutes vs. about 30 min...
August 28, 2006 at 7:17 am
Thanks for the tip, but we already checked memory and cpu utilization. The cpu and memory is hardly used. It's very idle... We have SQL server setup to use min....
August 25, 2006 at 2:27 pm
Viewing 10 posts - 61 through 70 (of 70 total)