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 |
|
sfjtraps
Yak Posting Veteran
65 Posts |
 Posted - 2009-08-26 : 16:47:33
|
| I'm having an issue with a Windows service that's being shut down on a server. I was told that as more queries are added to a sql database, there are possibilities of more threads/processes being used which can shut services down sometimes.I'm somewhat new to sql server. Does anyone have any ideas of how I can optimize the server to lighten the load on it? The .mdf and .ldf files aren't that big (less than 300,000kb). Also, the recovery model is set to 'Simple'.If anyone has anything else I can check I would greatly appreciate it. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-26 : 17:22:03
|
| What service is shutting down? What is the SQL Server resource usage like? Memory? CPU? Disk?Why do you suspect SQL Server is causing this problem?Did you check the Event log? And the SQL Errorlog? |
 |
|
|
sfjtraps
Yak Posting Veteran
65 Posts |
Posted - 2009-08-26 : 17:41:52
|
| It's a Windows service for a Wonderware product call Logic Manager. I'm suspecting that the root of the issue may be in sql because it didn't start happening until tables were being queried more often.The memory, CPU, and Disk look fine. I'm not sure about the sql resource usage, event log, and sql errorlog because I don't know where they are located to check them. I can try to google there locations.Thanks |
|
|
|
|
|
|
optimize sql server