SQL Engine

Question

SQL Engine

subbarayudu.net 37258

Mr or Mrs. 500

Points: 540
More actions
February 19, 2010 at 5:09 am

#211301

May I know the server starting modes.
scinorio... Once we open any file or notpad it will take 2 or 3 seconds...the same scinorio sql server also take some 15 to 20 seconds time once we start the server. these time stamp it proccees the 3 modes then only sql server is started.
I don't know what are those modes. Please if you know please share me.
Thanks
Subbarayudu

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Sorry, I don't understand your question. What do you mean by 'starting modes'?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

subbarayudu.net 37258 Mr or Mrs. 500 Points: 540 More actions · Answer 2

Hi,

Starting modes means....

Forget starting modes..

Once we start Sql Server it will take time,then open SSMS ---> Connect to the sever window is oppend ---> we provide the user id and password ---> it will take 10 to 15 Seconds for checking the user id and password after that it will open. In these scenario from sql server starting to opening time it will take approximately 20 seconds. So now what will happened inside the sql server. If you people know please share with me.

Regards

Subbarayudu.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Still not following.

Are you interested in the startup process of the SQL service or the login process for a user connection?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 4

First, you need to realize that SSMS != SQL Server. SQL Server is a server service that starts up independently of SSMS.

SSMS is a program, like notepad. You can run PRofiler to see what is executed when you start up SSMS and connect.

subbarayudu.net 37258 Mr or Mrs. 500 Points: 540 More actions · Answer 5

Hi Gila,

I need the information about starting process only.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

There's an entire chapter on SQL's startup procedure in the book "SQL Server 2005 Practical troubleshooting"

In summary (and not necessarily in completely the correct order, some stuff runs in parallel):

Start up the background system processes

Locate and open the master database

Use the information in master to locate and open the other system databases

Recreate TempDB

Start the network listener processes

Use the information in master to locate and open the user databases

Ready for user connections.

Have a read through the SQL error log, many of the startup processes are logged in there.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

subbarayudu.net 37258 Mr or Mrs. 500 Points: 540 More actions · Answer 7

subbarayudu.net 37258

Mr or Mrs. 500

Points: 540

February 20, 2010 at 10:15 am

#1122350

Thanks Gila

Regards

Subbarayudu