Previous in Forum: RF Remote Control Prob.   Next in Forum: RF Remote Control Prob.
Close
Close
Close
2 comments
Rate Comments: Nested
Associate
Hobbies - Musician - New Member United States - Member - New Member

Join Date: Feb 2008
Location: Massachusetts
Posts: 50
Good Answers: 1

Why Does Sqlsrvr Run Constantly?

03/04/2008 8:37 AM

Good morning all,

I've recently installed Microsoft's VB2008. It's very nice. However, since downloading it Sqlsrvr seems to run all of the time. It's a bit of hog using more resources than any other application in the task manager.

I could set it's priority very low, correct? Or should I just kill it?

Regardless, what is it doing all of that time? "I's just gots to know"

Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Good Answers:

These comments received enough positive votes to make them "good answers".
4
Active Contributor

Join Date: Mar 2008
Posts: 15
Good Answers: 1
#1

Re: Why Does Sqlsrvr Run Constantly?

03/05/2008 12:10 PM

I assume when you say you installed VB 2008 you're talking about the Visual Studio Express addition, so my answer will lean toward that assumption. There is really only one main process that runs with the SQL Server Express edition installed and automatically run with VB: sqlserver.exe. If you accepted the default installation of SQL Server Express, then this service simply provides the basics of relational database management system including storage, processing and accesses to transactions within the database. Two other main processes, SQL Server Browser and SQL Server Active Directory Helper are also installed but don't typically run on a "standalone" computer. They require the installation of SQL Server on a server with Active Directory/DNS integration (for the former) and the latter is designed to host services in a client-server architecture using TCP/IP, VIA and other such protocols. Unless you are developing applications in VB that utilize a SQL Server database, you can navigate (on Windows XP) to Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools and choose SQL Server Configuration Manager. This opens a snap-in console where you can configure the service as you would like it. NOTE: Do not mistake the sqlwriter.exe process in the Task Manager as being one that hogs processor or paged memory resources. It only operates in the event of backups or restores on a SQL Server Database that use Volume Shadow Services.

Register to Reply Good Answer (Score 4)
Associate
Hobbies - Musician - New Member United States - Member - New Member

Join Date: Feb 2008
Location: Massachusetts
Posts: 50
Good Answers: 1
#2
In reply to #1

Re: Why Does Sqlsrvr Run Constantly?

03/05/2008 3:43 PM

Thank you very much for taking the time to explain this to me. Yes, your assumptions were correct. This is a copy of VB express and yes I did agree to the default installation of components. You may also have noted that I am new to world of programming and often don't know were to ask what. You have made things easier for me, thank you!

A complete and useful explanation!

Register to Reply
Register to Reply 2 comments

Good Answers:

These comments received enough positive votes to make them "good answers".

Previous in Forum: RF Remote Control Prob.   Next in Forum: RF Remote Control Prob.

Advertisement