Solved

How to Configure SQL Server 2008 R2 to avoid Qurey Process

Posted on 2014-02-18
3
103 Views
Last Modified: 2014-09-24
Hi Experts,
Our Database in sql server 2008 r2 goes down becoz of more insert and update statement executing in each minute , so that web site opening very slow.
Actually we have GPS Tracking system ( website ) in asp.net , more than 3000 devices send data each device sent his location each minute its mean each minute
it mean each minute 3000 rows inserted and 3000 rows updated.
so this is the reason of slowness of website.
Is any thing or configuration to keep sql server processing of query free ?.
so that our website working fast.

Thanks in advance
0
Comment
Question by:Asrar Azmi
3 Comments
 
LVL 7

Expert Comment

by:Kishan Zunjare
ID: 39867004
One solution can be you can maintain separate database for production website. Data from GPS will be inserted/updated into staging database. On particular time or through batch process you can move processed data to actual website database. Or you can use SQL Server Replication for this.

Hope this helps
-Kishan
0
 

Author Comment

by:Asrar Azmi
ID: 39869907
Thanks for your reply,
If the Database server is busy by the multiple query process how it can be access smoothly.

Can you please provide the steps ?
Our system work live we cannot make batch to update any thing as you told.
0
 
LVL 35

Accepted Solution

by:
David Todd earned 500 total points
ID: 39871189
Hi,

You can use replication to the reporting server. Replication can have a lighter load than a whole bunch of inserts/updates/deletes.

Realistically, how up-to-date does the reporting server need to be? second, minute, hour, day?

If day, then during the day pause the replication, and allow to catch-up/resync overnight. You could use snapshot replication for this, and take a new snapshot every night - depending on the volume of data vs the volume of changes.

HTH
  David
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

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…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

919 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

21 Experts available now in Live!

Get 1:1 Help Now