Solved

How to Configure SQL Server 2008 R2 to avoid Qurey Process

Posted on 2014-02-18
3
102 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
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.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

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

24 Experts available now in Live!

Get 1:1 Help Now