I have a client who uses a Line Of Business Application that is giving them trouble. They are an agricultural producer and the software essentially runs their company. It helps them control the growing, picking, packing, shipping, sales, receivables, etc. Pretty much everything. The whole system, hardware and software was installed new in June 2011.
What I'm hoping to get from your help is a method, a way to monitor the processes and performance around this program. I envision using the SQL studio and/or WIndows Reliability and Performance Monitor to monitor key aspects of the database performance while it's running. Hopefully, I can leave a perfmon running and maybe some live graphs that could indicate a bottleneck so Shipping user could call upstairs to the office *when they're having the problem* and the Admin User could glance at the graphs and spot a potential issue, or at least call me to take a look.
Problem and Specs
The problem primarily exists with the single Shipping computer. The entire system consists of the Server (specs below), one Admin PC ( a very new Optiplex 9090- I think- with Core i7 and SSD and plenty of RAM, Win7) and a Shipping PC - (another Optiplex, either i5 or i7, SSD and 4 GB RAM, Win7). The shipping user complains that aspects of their program slows down. It may be during printing labels or tickets, or creating a report. Generally during a time where the server would be expected to gather information and produce an output.
The problem started at the beginning of the install of this new system. At that time the shipping PC was a slightly older, maybe 2009 vostro, with decently fast specs.
-I replaced the whole PC with the fast Optiplex. It didn't solve the issue.
-I installed a good quality Gigabit managed 16 port switch at the server.
-I placed a gigabit switch at the shipping PC
-I replaced the ethernet cable from server switch to shipping switch - one single run of maybe 150'
- I get gigabit links all around.
Dell Server T310. Xeon X3470 2.93 GHz, 16 GB RAM, 64 bit
MS Server 2008 Standard SP2
SQL Server 2008 R2
From SQL Management Studio:
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Analysis Services Client Tools 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.0.6002.18005
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.4241
Operating System 6.0.6002