June 6, 2012 at 12:01 pm
Welsh Corgi (6/6/2012)
The reason for stopping & starting the service is proably classified.:-)I have used the Start & StopService method of the Win32_Service Class to do this.
I would not use SQL Server.
And it could be as simple as clearing a memory leak due to a poorly written service.
June 6, 2012 at 3:09 pm
I asked and she says the application support for a arcGis software told her to schedule restart service daily when it is at verison 9.0, she will check if the newer version 10. still needs it.
June 6, 2012 at 4:41 pm
sqlfriends (6/6/2012)
I asked and she says the application support for a ArcGIS software told her to schedule restart service daily when it is at verision 9.0, she will check if the newer version 10. still needs it.
Whoever wrote the ArcGIS Software needs to modify their code to free up memory so that the memory leak does not occur.
You should not have to stop & start the service.
The application software should not be installed on a SQL Server Machine.
Application software should always be installed on an application server.
If your application software has to be installed on the Database Server then whoever wrote the application software developers are not "Doing the Right Thing".
If the application software is so lame and you have to stop & restart the Service you should be calling Win32 Methods to do so.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply