Solved

Web Database

Posted on 2011-02-17
6
199 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
getting error Subquery returned more  than 1 value 6 22
find SQL job run average duration 24 54
SSMS Imprt data from Excel 7 20
Star schema daily updates 2 34
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

740 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