Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Location
    Johannesburgh
    Posts
    8

    Question Unanswered: SQL server 2000 hosting multiple apps problem

    HI all

    I have a relativley unique setup
    where all the sql servers have been consolidated
    so multiple applications are connected to their respective databases on the same SQL server

    The problem I have is when an app locks tempdb all the other apps that require it are blocked/slow

    The ?

    can tempdb be split or multiple tempdb's be created

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040

    -- This is all just a Figment of my Imagination --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •