Results 1 to 9 of 9

Thread: dbcc scans on MSSQL 2000

  1. 10-21-2003, 09:11 AM #1
    gvillaran
    gvillaran is offline Registered User
    Join Date
    Oct 2003
    Location
    Lima, Peru
    Posts
    14

    dbcc scans on MSSQL 2000

    hi, i'm monitoring a SQL server 2000 and every 5 minutues aprox. a dbcc scan is triggered on 2 databases only.

    how can i deactivate this scans or how can i define a longer period of time between them?

    thanks
    Reply With Quote Reply With Quote
  2. 10-21-2003, 11:39 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Which monitoring tool do you use? Do you know which process triggered dbcc scan?
    Reply With Quote Reply With Quote
  3. 10-21-2003, 11:46 AM #3
    gvillaran
    gvillaran is offline Registered User
    Join Date
    Oct 2003
    Location
    Lima, Peru
    Posts
    14
    monitoring tool: Spotlight
    database: SQL 2000 SP3

    i dont know which process triggers the scan,
    but i saw that is a "dbcc consistency check" on 2 of the databases.
    Reply With Quote Reply With Quote
  4. 10-21-2003, 02:14 PM #4
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    What kind of dbcc is it.

    is it dbcc trace on and off?
    Reply With Quote Reply With Quote
  5. 10-21-2003, 02:29 PM #5
    gvillaran
    gvillaran is offline Registered User
    Join Date
    Oct 2003
    Location
    Lima, Peru
    Posts
    14
    i was looking and yes is trace on and off

    whats that for?
    Reply With Quote Reply With Quote
  6. 10-21-2003, 03:07 PM #6
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    The tool needs to turn on certain trace flag to get sql server info. You can try reset pooling interval in spotlights.
    Reply With Quote Reply With Quote
  7. 10-21-2003, 03:14 PM #7
    gvillaran
    gvillaran is offline Registered User
    Join Date
    Oct 2003
    Location
    Lima, Peru
    Posts
    14
    ok, how can i do that?

    is an option in spotlight?
    Reply With Quote Reply With Quote
  8. 10-22-2003, 08:00 AM #8
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Should check doc or with vendor.
    Reply With Quote Reply With Quote
  9. 10-22-2003, 12:26 PM #9
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    It must be flag 208, it is set whenever anyone does SET QUOTED IDENTIFIER ON/OFF.

    Nothing to worry about.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules