Post reply

SQL Standard Vs. Enterprise

  • August 21, 2002 at 12:22 pm

    #79365

    I am currently running SQL Server 2000 Standard. My database contains 6 million records. When I try to query this table I get ODBC timeout errors.

    My question: What is the most amount of records that SQL standard can run with? Is there a way to get rid of the ODBC timeout errors? At what point (size) should I upgrade to SQL Enterprise.

    Thanks

    james

  • August 21, 2002 at 5:13 pm

    #434989

    Upgrade to Enterprise if you need native log shipping or want to use more than 3g of memory. On the timeouts, have to see why before you can decide what to do. Could be just some tuning, could need faster drives, or more memory, or more CPU.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

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

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