February 4, 2012 at 8:46 am
Hi All I want to reserve memory.
I am not using sql full text nor the analysis service in my application
If I went to computer/manage/services/MSSQLFDLauncher and stopped both the sql analysis and sql fulltext services
will this affect my application and will that release some memory for me.
Thanks
February 4, 2012 at 9:05 am
These services should not effect the running of SQL Server if stopped.
February 5, 2012 at 4:36 am
:hehe:
Sorry i forget also to post an Important post relate to your query
Configure each service used by SQL Server 2005 suite of products. Services include the relational database management service (SQL Server service), SQL Server Agent, Analysis Services, Integration Services, Full-Text Search, SQL Server Browser, Notification Services, and Reporting Services. Each physical host could have one or more instances of some of these services. As you might imagine, managing this number of services can quickly become unwieldy, particularly on a host also used for other applications besides SQL Server. Surface area allows you to configure whether each SQL Server related service should be disabled, startup automatically or manually. You can also use the tool to start, pause, stop and restart each service. You can also disallow remote connections to SQL Server and Analysis Services instances. Disabling the unnecessary services can help reserve system resources for those services that are necessary for normal operation of your applications.
Configure features for each service installed on the current host. You can configure the following options for SQL Server instances:
Ad Hoc Remote Queries
CLR enabled
Remote Admin Connections (the tool refers to this setting as DAC)
OLE Automation Procedures
SQL Mail XPs
Web Assistant Procedures
Xp_cmdshell
HTTP access to SQL Server through endpoints
Service Broker
February 5, 2012 at 8:23 am
Thank you all
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply