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 |
|
dadunn
Yak Posting Veteran
67 Posts |
 Posted - 2001-10-09 : 13:11:03
|
| I have a system which is a 4 X700 MHz Zenon Processor box with 2 GB of memory running SQL 7.0 SP2.The developers have added a lot of reporting functionality using Microsoft Access with linked tables to the server.The Access queries take an incredible toll on the servers performance.Processor Query Length in within acceptable limits, although at times all four processors can be as high as 60% or more utilization.Paging is incredible and it appears that a great deal of the Page Faults/sec are soft page faults coming from SQLSERVER.exe.Short of whacking the developers and ripping out all of the Access usage, what could I do to increase performance?The box will accept up to eight GB of memory. I would like to see it with at least four GB if not eigh to see if that eliminates the paging.ODBC does not seem to have the ability to work on the result set, but rather issues comannd after command after command.Has anyone else seen these kind of performance issues using Access or other ODBC apps as front ends to the database?>>>>>>>>>>>>>>>>>>>>>>>Just sittin' around waiting for the servers to crash.Dave |
|
|
|
|
|
ODBC APPS and SQL Server Performance