Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL "Starting up database 'ReportServerTempDB'. message

Posted on 2011-09-14
7
Medium Priority
?
1,958 Views
Last Modified: 2012-05-12
Let me start out by saying I know nothing about SQL Server. I am running SQL 2008 Express for our acounting software and I'm seeing a LOT of messages ( sometimes every few seconds)  in the application log for reporting services, this being one of them:
"Starting up database 'ReportServerTempDB'.

 Is there something I can do to get rid of these, or, more importantly, would this have any affect on performace, because of some configuration setting that is causing the Reporting server to do things more regularly than needed?

Thanks,
CJA
0
Comment
Question by:cja-tech-guy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 8

Accepted Solution

by:
venk_r earned 1000 total points
ID: 36540034
Reporting Services automatically "wakes up" every ten minutes or so to check various things. To do this check, it has to query it's databases. When it queries the database, it has to open the database, which results in the log entry you are seeing.

The "wake up" behavior of RS is normal behavior. The need to open the database is a result of the default settings of SQL Express that all databases have Autoclose turned on, so when there is no activity in a database, it is closed.

As I said, this is normal behavior, if the log entries really bug you, you have to Set the Autoclose property on the RS databases to False, this way they won't close, and thus not need to be opened, which causes the Log Entry.

0
 
LVL 5

Assisted Solution

by:VENKAT KOKULLA
VENKAT KOKULLA earned 1000 total points
ID: 36542631
Please keep the Auto close option "false" if you dont want to see that message again and again.

To make it False, Go to Database properties--> Options-->then you can see 'Auto Close' option in middle of the window, select it as False.

Might it will help you.

--Venkat
0
 

Author Comment

by:cja-tech-guy
ID: 36542925
I checked the settings in Options and "Auto Close" was already set to "false".  Any other things I should check?  I also noticed the message in the log after hours when no one is using the database.  Only the back up runs over night.

Thanks,

CJA
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 8

Expert Comment

by:venk_r
ID: 36542977
If I were you I wouldnt worry.Its just a regular check by the reporting service engine.It shouldn't impact your performance at all.
0
 

Author Comment

by:cja-tech-guy
ID: 36543080
OK. Thanks
0
 

Author Comment

by:cja-tech-guy
ID: 36543098
I was looking at the wrong database.  When I checked the reportservertempdb, it was set to "true".  Since you are telling me it is a normal process and that it won't affect performance, I will leave it alone.

CJA
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36543129
Well, Since you said go ahead and set it to false. It isnt going to benefit anything with setting it to true truely speaking.
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question