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 |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2003-09-24 : 13:24:17
|
| Hi, We are getting following kind of errors when doing lots of insert/select:Time-out occurred while waiting for buffer latch type 2 for page (1:2900608), database ID 16.; SQLSTATE = 42000; HRESULT = e1500013 According to article 167711 it looks like our disk subsystem is slow. This article specify to change options such as max sync io, resource timeout etc but all these options are obsolete in sql 2000. What can we do avoid this problem except changing the hardware?Is there any option that we can set at sql server level? Thanks--Harvinder |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-24 : 13:34:20
|
| The solution is to install the latest service pack for SQL Server, which is currently service pack 3a. If you already have it installed, then the cheapest hardware solution would be to increase the amount of memory.Is SQL Server the only application running on this box? If it isn't, that's probably the problem. When you combine applications, such as IIS and SQL Server (which is very bad), you need to have a very powerful machine in order for either of them not to suffer.Tara |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-24 : 13:34:48
|
| Here's an article that I found when I searched MS' knowledge base:[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;309093[/url]SQLTeam doesn't show the semi colons in the above url, put semi colons in the url where you see spaces above.Tara |
|
|
|
|
|
|
buffer timeout error