Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    9

    Unanswered: MS SQL Record Limit

    Quick question, is there a record limit in MSSQL assuming that we don't use a identity key. I am going to be using a table to sava mail server logs. It will create about 5000 records a minute. Also are there any perfomrance issues once you reach a certain numberof records, assuiming i am indexing one of the columns.

  2. #2
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    limited by available storage

    [Books Online] Maximum Capacity Specifications

    look for rows per table

    or LINK

    now 5000 rows a minute for how long??

  3. #3
    Join Date
    Jan 2004
    Location
    Shanghai,China
    Posts
    76
    drop any index before inserting data.
    when transaction complished,recreate index.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Also plan to archive the data in order to manage the database efficiently without any issues. say archive the data after a week or month or so.

    This way you can ease the administration of the database on the terms of performance etc.

    Refer to http://www.sql-server-performance.com for tips and tricks on performance issues.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Nov 2003
    Posts
    9

    Thanks

    Thanks for all your help, I am going to do some testing and see what happens.... the best way to learn is to do.

Posting Permissions

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