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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-29 : 07:45:54
|
| Ali writes "I have a network of about 84 PC+28 MACs and a number of Networked printers including 1 color printer (networked).All machines, including servers and printers have 10/100 Ethernet adapters.PDC is running Windows NT 4.0 SP6a, while PC clients are running Windows 98 SE.I also have a MS SQL Server running over P4/2.4GHz with 1.0 GB RAM, SCSI RAID, 10/100 NIC and Windows 2000 Server. I am using a locally developed application 'A' that integrates all departments.However, users+developers are not satisfied with the performance and blame the network for which no one else complains except users of that application 'A'.I also have a proxy server on the same LAN.Could someone help me as to how should I ascertain the real area of problem: network, SQL Server or the application 'A'?Ali" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-29 : 12:28:24
|
| You should run Performance Monitor on the database server, as well as on any application servers that this app might use, to determine if there is a bottleneck on the servers. If there isn't, then then problem isn't on the servers. Has anyone put a network sniffer on the network to determine if there is any unusual activity, such as a worm?Tara |
 |
|
|
|
|
|
Network/SQL Server/Application Performance