Win2003 ii6 1 g why always buffer pool size SQL2008 database cannot be recycled, other small site is a separate pool with server recovery normal, open the task manager found several W3WP. EXE, using the task manager cannot end, other sites at the moment recycling pause and start the site can be, even if the site operation will be suspended or start cannot succeed, CPU resources last four nuclear 8 g generally used about 10% instantly 30, SQL set the maximum amount of memory to 2048 MB

CodePudding user response:

Should check, WEB applications, which function is the WEB usually only in this way, on a visit to optimize WEB application