Forum Replies Created

Viewing 10 posts - 61 through 70 (of 70 total)

  • RE: stored procedure shows running from a different db context

    Thanks, I'll research the fix further.  Maybe it is an answer to my problems.

  • RE: sudden slow down

    dbcc dbreindex was used to rebuild the indexes.

  • RE: sudden slow down

    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.

     

  • RE: sudden slow down

    Yes, we did run profiler.  It shows the usual stuff that we see on a normal day too.

  • RE: sudden slow down

    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...

  • RE: Failing over a witness server

    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...

  • RE: DB Mirroring without Windows authentication

    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...

  • RE: Disk problems?

    Turns out it was a problem with the controller.

  • RE: Disk problems?

    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...

  • RE: Disk problems?

    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....

Viewing 10 posts - 61 through 70 (of 70 total)