A common scenario in SQL Server environment that often application users complained about slow performance and same time you observe high CPU usage/spikes on the SQL Server instance, so better to follow the methods from HighCPU-whyitis blog and still you have not seen no sign of resolution to the problem, go down this blog. Back to basics, by default SQL Server (until 2000 version days) does not create a new data access plan to retrieve the information from the database. So it will be optimized when...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/perftune/archive/2007/10/25/2549.aspx