Recovery is checkpointing database ...?

[jballum]

Whenever SQL Server is restarted in the ERRORLOG the following messages always appear:

Starting up database 'MYDATABASE'.
Clearing tempdb database.
Recovery is checkpointing database 'MYDATABASE'.
Starting up database 'tempdb'.
Recovery is complete.
...
Starting up database 'MYDATABASE'.

another hint to the problem might be the following error found a lot:

"This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 6 queries and performance may be adversely affected."

Any ideas on the trouble I should be looking for?

Thanx

JB

 

[tlbroadbent]

Which version of SQL Server are you running? The first few messages are quite normal. The message about concurrent queries indicates you must be running MSDE or SQL Server Personal Edition. Check the version using SELECT @@version. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[jballum]

Thanks for the prompt response TL.

I think it may be Personal Edition. With Personal Edition, is there a maximum number of concurrent queries of 8?

JB

 

[tlbroadbent]

I don't think the maximum number of concurrent queries is 8 but the optimum number is 8. Theoretically, performance will degrade if more than 8 queries are executed concurrently. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[jballum]

Great TL.

Thanks again.

JB