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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Statement does not reference

Author  Topic 

mike13
Posting Yak Master

219 Posts

Posted - 2012-09-19 : 08:40:10
Hi All,

I got this 6gig DB for a ecomerce website
with about 2K unique users a day.
a dual 4 core xeon and 32 gig of memory

and it used to only use 2 to7% proccesor power
now it is constantly peaking to 80 90%

code didn't change or and this

Running DB tuning which give back this error, no idea why it says that

S001 exec SP_SYS_Last10searches @lang=N'en' RETURN 123 Statement does not reference any tables

thanks
   

- Advertisement -