Solved

Web Database

Posted on 2011-02-17
6
197 Views
Last Modified: 2012-05-11
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.

0
Comment
Question by:Yadtrt
  • 3
  • 3
6 Comments
 
LVL 15

Expert Comment

by:gplana
ID: 34919813
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
 
LVL 15

Expert Comment

by:gplana
ID: 35046113
Have you tryied what I have told to you about indexes ?
0
 
LVL 6

Author Comment

by:Yadtrt
ID: 35046146
I know this before I post the question, index is not fragmented as there is no transaction in the database.
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 6

Accepted Solution

by:
Yadtrt earned 0 total points
ID: 35046153
The problem was from a view which the relation was broken and it became a crossjoin
0
 
LVL 15

Expert Comment

by:gplana
ID: 35046292
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
 
LVL 6

Author Closing Comment

by:Yadtrt
ID: 35106978
that was the solution I found it my self
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question