Web Database

I have a website, which has SQL server express database it is about 20 tables with about 10,000 records. The database has very less transactions most of the loads are coming from select as too much user opening the website.
Now I have a lot of traffic on the CPU of the server what do you advise me to reduce some load on the database.

LVL 6
YadtrtAsked:
Who is Participating?
 
YadtrtAuthor Commented:
The problem was from a view which the relation was broken and it became a crossjoin
0
 
gplanaCommented:
See if you have index for the columns you are using to filter on the select (i.e. the columns that appear on the where clause). This would improve a lot the performance.
0
 
gplanaCommented:
Have you tryied what I have told to you about indexes ?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
YadtrtAuthor Commented:
I know this before I post the question, index is not fragmented as there is no transaction in the database.
0
 
gplanaCommented:
ok, then if you have solved the question yourself, you can assign the points directly to you. I think this is better than delete question, so the solution will be published.

Regards
0
 
YadtrtAuthor Commented:
that was the solution I found it my self
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.