Post reply

DB Lockup on Query?

  • May 14, 2007 at 2:45 am

    #172378

    Have two databases:

    Ones an Archive Database the others a Transaction database.

    If i query the Archive database it sometimes locks up the transaction database.

    All writes to the transaction database fail at this point.

    Note: All writes to the transaction database are not enclosed in

    Begin Tran and Commit etc.

    Both databases are on the same disk array, its a stripped set.

    Both database are on the same instance of the sqlserver2000.

    1gig of memory is allocated to the instance.

    Indexes are maintained on both DBs.

    Archive DB is about 10Gig, tran db about 3Gig

    What could it be??

     

    Thanks

     

  • May 14, 2007 at 2:50 am

    #706142

    have you tried using table hints e.g. WITH NOLOCK

    Everything you can imagine is real.

  • May 15, 2007 at 12:29 am

    #706404

    Post one of the queries that is known to cause this problem.

    Have you reviewed the query plan?

    Are the log files on the same drive as the data files? What about tempdb?

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply