|
Home > Archive > MS SQL Server > April 2005 > SQL Server performance problems
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server performance problems
|
|
|
| Hi,
I have a SQL Server 7 with 2000 users.
We have a maximum of 1020 concurrent users.
It is a proliant with 4 processors.
Paging system is 2 GB.
The tempdb is 2.5 GB
The production db is about 22 GB.
It is a client/server application.
Question:
Users complain that connections get lost and system is slow.
Example: user is working with system and sudenly gets disconnected.
I checked network and it is fine. Every router takes less than 80 ms.
I also increased the number of concurrent users and the tempDb.
Any idea how to proceed will be appreacited
Regards,
Gil
| |
| Mike Epprecht (SQL MVP) 2005-04-25, 11:23 am |
| Hi
What error is the user getting when the disconnection happens? What type of
application is it or is it Access/Excel?
80ms for a router is terrible performance.
How many users does sp_who2 show?
Regards
Mike
"Gil" wrote:
> Hi,
> I have a SQL Server 7 with 2000 users.
> We have a maximum of 1020 concurrent users.
>
> It is a proliant with 4 processors.
> Paging system is 2 GB.
>
> The tempdb is 2.5 GB
> The production db is about 22 GB.
> It is a client/server application.
>
> Question:
> Users complain that connections get lost and system is slow.
> Example: user is working with system and sudenly gets disconnected.
>
> I checked network and it is fine. Every router takes less than 80 ms.
> I also increased the number of concurrent users and the tempDb.
>
> Any idea how to proceed will be appreacited
>
> Regards,
> Gil
>
| |
|
| Hi,
It is a Client /server application. Application runs on VC++ 5
Here are exact numbers for routers: Made with tracert iPADD_SERVER from one
of users machine.
1 <10 ms
2 <10 ms
3 31 ms
4 31 ms
5 47 ms
At this moment it is 780 users but keeps growing .
Other information. Runs on Windows 2000 Advanced server SP 4
"Mike Epprecht (SQL MVP)" wrote:
[color=darkred]
> Hi
>
> What error is the user getting when the disconnection happens? What type of
> application is it or is it Access/Excel?
>
> 80ms for a router is terrible performance.
>
> How many users does sp_who2 show?
>
> Regards
> Mike
>
> "Gil" wrote:
>
|
|
|
|
|