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 |
|
Guile
Starting Member
3 Posts |
 Posted - 2012-08-29 : 04:48:22
|
| Dear all,I am experiencing severe problems with SQL Server 2008.I have googled on the web to find any solutions with no success.Here is the version of SQLserver I use (SP3 + cumulative patch 5)10.0.5785.0 SP3 Web Edition (64-bit)Regularly, SQL server stops responding. I cannot connect to it from whatever machine on the network nor on the local machine running it.When this problem happen, when using SQL Server Management studio on the machine running the server, I cannot connect to it, I cannot run any sql command.The only way to make it work again is to restart the service (MSSQLSERVER).SQL Server is running on a core i7 with SSD and 16GB Ram. The database I am using is not very big (11 GB).Thanks for your help. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-08-29 : 05:03:20
|
| Can you post any error messages from Windows System Logs and SQL Server Logs relevant to the time frame?Are there any application related details - such as BACKUPs are slow?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
Guile
Starting Member
3 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-08-29 : 11:02:47
|
| That would be interestining to know the feedbackJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
Guile
Starting Member
3 Posts |
Posted - 2012-08-31 : 04:50:48
|
| Since I have changed max_workers_count (3 days), I haven't experienced any pb anymore. If during the next week, it is still ok, there are good chances that this fix solved the pb.Thx Jack again for pointing me where to look for! |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
|
|
SQLServer 2008 stops responding regurlarly