Solved

Web Database

Posted on 2011-02-17
6
195 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now