[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Web Database

Posted on 2011-02-17
6
Medium Priority
?
203 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Independent Software Vendors: 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!

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

650 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