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 |
|
ranganath_mehta
Starting Member
4 Posts |
 Posted - 2002-08-19 : 04:36:02
|
| Hi,I hv some 22 months of experience in SQL Server 7.0. Now I have observed that with increase in the number of users the SQL CPU utilisation increases as much. I have tried finding out the cause for it and I have used SQL profiler used indexes etc.. to fine tune the performance. I have not succeded much I shud say. Even now I am facing this problem. I spoke to couple of my friends and they said that this is a known problem in SQL Server 7.0 and there is nothing much we can do about the same. Few Qsa) Are these guys correct? b) Is my approach correct wherin I have tried to find out if queries and tables that are being used/accessed are the cause of problem? c) Can you suggest some other way I can handle this?Thanks in advanceRegardsRanganathRanga |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-19 : 08:40:16
|
| It's not a "problem", it's a natural increase in processor usage as more users access the same computer. If you have a horse pulling a cart, naturally the horse will slow down if you keep throwing more stuff into the cart.How many users are hitting the SQL Server? And what kind of CPU are you using? If you have a lot of users hitting a low-end machine then there isn't much you can do other than cut back on users or get more powerful hardware.Running Profiler can help, but there are other things to look for:-How are users accessing the SQL Server? If it's a web or other front-end, are you using ADO? -If yes, are you using connection pooling? If not, then you'll have an execessive number of connections that will slow the machine down.-Are you properly creating and destroying connections? If not, the same applies, too many connections will be open. |
 |
|
|
ranganath_mehta
Starting Member
4 Posts |
Posted - 2002-08-20 : 03:20:00
|
| Hi RobVolk,My servers has got 1 GB RAM with a Intel CPU. I can assure that the server is high end Compaq Proliant 550 Series. Yes our application uses a ADO but does not have connection pooling,regarding making and closing connections yes they are made and closed properly.Is there anything else I can do?RegardsRangaRanga |
|
|
|
|
|
|
Number Of Users