Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Question Unanswered: Admin Performance Issues, Large amount of DBs

    I have a large amout of dbs (150) on my SQL Server and when using the enterprise manager to do administrational tasks like Backup, Restore etc. it takes 1.5 hour to open the Database folder. Server is 2xP4, 3Gb RAM. Any ideas on how to manage this number of dbs on the same server and instance of SQL.
    Cheers!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Use scripts ???

    -PatP

  3. #3
    Join Date
    Mar 2004
    Posts
    45
    If you can run utilities on server itself, register server as "(LOCAL)" which is local named pipes. Also make sure "Enable shared memory protocol" is checked in Client Network Utility on server.

    Otherwise if you can not use server console to run utilities make sure you use TCP/IP protocol.

    Hans.

Posting Permissions

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