We have several databases but the main database is just under 10 gig. The issue i am seeing is when users are using rendering reports or other peak time activities the processor stays high, sometimes 100% usage. We use a custom written software that I wrote and i have removed a bunch of the sql processing to c# on the client machine but still see high processor usage and its always sql server using it, this is mainly using task manager. Also there are times that in SSMS a simple select statement can take seconds to run.