Results 1 to 11 of 11
  1. #1
    Join Date
    Jan 2004
    Posts
    11

    Unhappy Unanswered: Starting Database 'XXXXX' often in logs

    Hi,

    I've got a sitatuation where one of our sql databases appears to be frequently "starting". The log entry looks like:

    Starting up database 'Database'.

    And seems to occur at irregular intervals and does not seem to be inline with any other db activity....i.e. transaction log backups, insertions or reads.

    This DB is fairly busy receving inserts from our PBX CTI software almost constantly.

    Note this is the only DB on the server displaying this behaviour (we've got two named instances running with several databases in each).

    Any help / pointers appreciated.

    Rgds,
    SLE

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Can you post the contents of the error log?

    Who else has rights to this box?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2004
    Posts
    11
    I've just noticed that the SPID of the "Starting" event is the SQL Server Manager process from my workstation.....is this the Enterprise Manager doing this? Why?

  4. #4
    Join Date
    Jan 2004
    Posts
    11
    Here's a sample of the logs the entries marked "**" are the ones I'm talking about:

    27-08-2004 08:15:01.0 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    27-08-2004 08:15:00.9 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    27-08-2004 08:15:00.8 logon Login succeeded for user 'YYY--XY\myuid'. Connection: Trusted.
    27-08-2004 08:15:00.5 logon Login succeeded for user 'YYY--XY\myuid'. Connection: Trusted.
    27-08-2004 08:15:00.1 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    27-08-2004 08:15:00.1 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    ** 27-08-2004 08:14:54.5 spid54 Starting up database 'myDB'.
    27-08-2004 08:14:54.5 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    27-08-2004 08:14:23.6 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    27-08-2004 08:14:18.5 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    ** 27-08-2004 08:14:17.7 spid54 Starting up database 'myDB'.
    27-08-2004 08:14:17.7 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    27-08-2004 08:14:13.4 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    27-08-2004 08:14:13.1 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    27-08-2004 08:14:08.3 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    ** 27-08-2004 08:14:07.8 spid54 Starting up database 'myDB'.
    27-08-2004 08:14:07.8 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    27-08-2004 08:14:02.9 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    27-08-2004 08:14:02.8 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    27-08-2004 08:14:00.7 logon Login succeeded for user 'myDB'. Connection: Non-Trusted.
    ** 27-08-2004 08:14:00.5 spid54 Starting up database 'myDB'.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Pop into Query Analyzer and try:
    Code:
    SELECT DatabaseProperty('IsAutoClose')
    If it comes back anything other than a zero, use:
    Code:
    ALTER DATABASE myDb SET AUTO_CLOSE OFF
    -PatP

  6. #6
    Join Date
    Jan 2004
    Posts
    11
    Quote Originally Posted by Pat Phelan
    Pop into Query Analyzer and try:
    Code:
    SELECT DatabaseProperty('IsAutoClose')
    If it comes back anything other than a zero, use:
    Code:
    ALTER DATABASE myDb SET AUTO_CLOSE OFF
    -PatP
    Looks like this was the issue - Thank you for your help!

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Well like I said...

    Who else has sa to the box?

    And I did not know about that property....what's it do?

    Oh, never mind....bol here we go....

    EDIT: That didn't take long...begs the question...why would ANYONE want to incurr the overhead?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  8. #8
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I think it was meant for people who use SQL Server on their laptops. I guess it helps free up memory for those times that you don't happen to need the database. On a server, you are right, I don't think there would be any use for it, except for salespeople to make a pitch.

  9. #9
    Join Date
    Dec 2002
    Posts
    1,245
    IIRC, Autoclose was really intended to be a feature for PDAs running the CE version.

    Regards,

    hmscott

    Quote Originally Posted by MCrowley
    I think it was meant for people who use SQL Server on their laptops. I guess it helps free up memory for those times that you don't happen to need the database. On a server, you are right, I don't think there would be any use for it, except for salespeople to make a pitch.
    Have you hugged your backup today?

  10. #10
    Join Date
    Feb 2004
    Posts
    492
    hmmz... curiosity, how (well?) does sqlserver run on a pda?

  11. #11
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The AUTO_CLOSE parameter was actually added for MSDE 1.0. It allowed SQL Server to close down databases that weren't in use, which was closer to the behavior of Jet.

    SQL-CE actually runs pretty nicely on a Win-CE machine (as long as you are sane in your coding). So does DB2. Amazing how far the little beggars have come!

    -PatP

Posting Permissions

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