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 |  
                                    | mike13Posting Yak  Master
 
 
                                        219 Posts | 
                                            
                                            |  Posted - 2012-09-19 : 08:40:10 
 |  
                                            | Hi All,I got this 6gig DB for a ecomerce websitewith about 2K unique users a day.a dual 4 core xeon and 32 gig of memoryand it used to only use 2 to7% proccesor powernow it is constantly peaking to 80 90%code didn't change or and thisRunning DB tuning which give back this error, no idea why it says thatS001	exec SP_SYS_Last10searches @lang=N'en'		RETURN	123	Statement does not reference any tablesthanks |  |  
                                |  |  |  |