Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rj_khatri
Starting Member
13 Posts |
 Posted - 2003-07-10 : 02:11:28
|
Dear FriendsHi!I executed a file on the SQL Server 7 for approx 900 users. It was a system resource consuming file. The sql file completed but when I checked the results i found that execution was aborted/failed for almost half of the users (not randomly but at last in the list).I check the ERRORLOG file and observed that PUBS, Northwind and one of client's database files (There are 3 client database) are continuously starting and closing as per the following :2003-07-08 15:24:08.45 spid28 Starting up database 'client'.2003-07-08 15:24:08.45 spid28 Opening file D:\Client\client_Data.MDF. 2003-07-08 15:24:08.48 spid28 Opening file D:\Client\client_Log.LDF. 2003-07-08 15:24:08.68 spid28 Closing file D:\Client\client_Data.MDF. 2003-07-08 15:24:08.71 spid28 Closing file D:\Client\client_Log.LDF. 2003-07-08 15:24:08.74 spid28 Starting up database 'Northwind'.2003-07-08 15:24:08.74 spid28 Opening file d:\data\DATA\northwnd.mdf. 2003-07-08 15:24:08.79 spid28 Opening file d:\data\DATA\northwnd.ldf. 2003-07-08 15:24:09.10 spid28 Closing file d:\data\DATA\northwnd.mdf. 2003-07-08 15:24:09.14 spid28 Closing file d:\data\DATA\northwnd.ldf. 2003-07-08 15:24:09.17 spid28 Starting up database 'pubs'.2003-07-08 15:24:09.17 spid28 Opening file d:\data\DATA\pubs.mdf. 2003-07-08 15:24:09.23 spid28 Opening file d:\data\DATA\pubs_log.ldf. 2003-07-08 15:24:09.43 spid28 Closing file d:\data\DATA\pubs.mdf. 2003-07-08 15:24:09.46 spid28 Closing file d:\data\DATA\pubs_log.ldf. 2003-07-08 15:24:10.74 spid28 Starting up database 'client'.2003-07-08 15:24:10.74 spid28 Opening file D:\Client\client_Data.MDF. 2003-07-08 15:24:10.78 spid28 Opening file D:\Client\client_Log.LDF. 2003-07-08 15:24:10.92 spid28 Closing file D:\Client\client_Data.MDF. 2003-07-08 15:24:10.95 spid28 Closing file D:\Client\client_Log.LDF. 2003-07-08 15:24:10.99 spid28 Starting up database 'client'.2003-07-08 15:24:10.99 spid28 Opening file D:\Client\client_Data.MDF. 2003-07-08 15:24:11.01 spid28 Opening file D:\Client\client_Log.LDF. 2003-07-08 15:24:11.17 spid28 Closing file D:\Client\client_Data.MDF. 2003-07-08 15:24:11.20 spid28 Closing file D:\Client\client_Log.LDF. 2003-07-08 15:24:11.31 spid28 Starting up database 'Northwind'.And likewise it goes on.I want to know whether something is going wrong with settings or any virus problem. Does it also consume resources and because of this my sql file execution was aborted/failed.Any idea please.  Thanks.Rajesh Khatri |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-07-10 : 02:33:36
|
| These databases have the autoclose option on. You should switch this off on a production server by either right clicking on the database in EM and choosing Properties,go to the options tab and uncheck autoclose ot by using sp_dboption (see BOL for syntax). On a production server you should also drop the Northwind and pubs databases, these are just demo databases for development/learning purposes.HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
 |
|
|
|
|
|
Frequently Opening/Closing the database files.