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 |
|
greenxiar
Starting Member
2 Posts |
 Posted - 2011-11-27 : 23:27:50
|
| I need to update field value of one record frequently to save the status of something. The update frequency may be 1000 time per second. How about the disk? Does this operation cause disk corrupting? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-28 : 03:08:22
|
| 1000 times per second? what status are you changing at this rate? also are you doing it as a batch operation or one per row?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
greenxiar
Starting Member
2 Posts |
Posted - 2011-11-28 : 03:25:52
|
| Several records per one table. Every record preserve a version number tracing a distributed object state, check it if remote command is executed in order.The remote command send to object may be 1000 times per second. This is a heave duty of sql server, i worry about the disk failure. |
|
|
|
|
|
|
Update one record value frequently, how about disk