Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hayeser
Starting Member
2 Posts |
 Posted - 2008-03-19 : 12:45:42
|
| Hi,I am working on an application to analyse down time on a production line system. The system has about 40 rows inserted per minute. The inserts are coming from about 10 different stations.I need to a analyse the downtime between each insert from each station. The plan is to copy the data to another database on a different server so as not to affect the live system that is being updated by the production line. However the initial requirement was to do this at night while the production line was down but now they want the data to be updated every 3 hours which means performing this huge query while the production line is bombarding the DB with inserts.I am wondering what is the best way of doing this. Is there any way I can limit the abount of processor this proceedure will take. Any advice appreciated,Thanks,Sean |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2008-03-19 : 18:55:03
|
| I recon you should be ok. 40 rows per minute is not a lot. Why do you think this will be an issue? Have you tested it at all or is this speculation?If you are concerned about contention then check out the multi row versioning options in 2005. It removes a lot of the blocking of readers by writers but it doesn't sound like you have much to worry about. |
 |
|
|
hayeser
Starting Member
2 Posts |
Posted - 2008-03-25 : 06:55:49
|
| Thanks for the reply LoztInSpace,TBH I am not overly familiar with SQL Server, most of my experience has been on MYSQL. As the SQL server DB is supporting the production line I have been reluctant to do too much experimenting on it but the main table I am selecting from has over 11 million rows and a select * from it takes over 10 minutes. I was assuming it was taking this long was due to the production line inserts and that my query was more than likely also having an adverse effect on the live system.I am currently working in 2005 but I just have a management studio express client to work with. I am not sure what facilities if any are available on it to check isolation levels or resources per query on this.Thanks in advance |
|
|
|
|
|
|
Selecting from table with lots of inserts