Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Rochester, NY
    Posts
    135

    Question Unanswered: NT 4.0 SP6 is @GB file size a concern?

    Currently have a version 7 database that is 2.23 GB and noticing that the
    size utilized by 5 indexes is literally 200 times the size of the data in 6 tables. There also appears to be some missing data...

    Could the problems I am experiencing be related to the NT 2GB limit issue?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    No that doesn't seems to be an issue.

    Run SP_SPACEUSED @updateusage='true' on the database and see the results.

    Also run DBCC checks against the database for any inconsistency.
    And to the SQL error log for any information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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