SQL Standard Vs. Enterprise

• Jamestown44

  SSC Rookie

  Points: 47

  More actions

  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

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  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
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter