February 7, 2008 at 5:54 am
Hi. I have an issue and I am unsure where to begin investigating. My company has invested in new hardware to house a new ERP system. The server(s) are pretty good spec and were configured as per SQL consultant recommendation:
ARRAY-A: RAID 1+0 Bay 1 Bay 2
C: 50GB (OS – MASTER / MODEL / MSDB)
E: 80GB (BACKUPS)
ARRAY-B RAID 1+0 Bay 3 Bay 4
F: 140GB (DATA + TEMPDB)
ARRAY-C RAID 1+0 Bay 5 Bay 6
G: 140GB (LOGS – ERP APPLICATION - TEMPDB)
Bay 7 Hot Spare
Windows 2003 Standard 64bit SP2 R2
SQL Server 2005 Standard 64 bit
8GB RAM
Issue:
Users run ERP application via desktop shortcut (application .exe housed in bin folder on SQL server)
The application launches. When users then attempt to perform any task the local system locks up. Local machine task manager shows the application.exe process as using 99% of the CPU.
Question: Is this a local issue or SQL?
Secondly if I kill the application process explorer.exe then takes over and uses 99% of the CPU.
I have to reboot the machine each time??
I have configured perfmon on the SQL server to monitor:
Avg Disk Queue Length (Max 0.023 Average 0.000)
Avg Disk Read Queue Length (Max 0.023 Average 0.000)
Avg Disc sec/Read (Max 0.003 Average 0.001)
Avg Disc sec/Transfer (Max 0.000 Average 0.000)
Avg Disk sec/Write (Max 0.000 Average 0.000)
Avg Disk Write Queue Length (Max 0.000 Average 0.000)
Disk Writes/sec (Max 22.996 Average 1.464)
Split IO/Sec (Max 3.999 Average 0.081)
Now I am no expert but the above values seem pretty low.
The Network runs at 1GB. The SQL server has a Teamed NIC running at 2GB.
Any advice on how to troubleshoot?
If you require further information please ask.
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 19, 2008 at 3:16 pm
are you saying your users are launching the app from a shortcut on the server ?
If so I can't see how that would work.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 19, 2008 at 3:48 pm
No the shortcut is on their desktop (points to an app on the server).
Hope that clears things up.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 20, 2008 at 9:43 am
ok so I didn't word that correctly - each user runs the application across the network from their workstation and the server the app is on is also the sql server?
I'd doubt that would work in any situation. Don't suppose you could mention the application name for our reference?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 21, 2008 at 1:58 am
Hi Colin. Maybe I have not been clear. The app is client server based and users connect via SNAC. Clients run application.exe from bin folder on sql server. Application bin folder contains config file that points to sql server.
The application is ERP System (.net). The initial post regards application hang maybe a local client issue. The system implementation is at an early stage (not a great deal of data but have migrated Product Codes / General Ledger / Customers / Suppliers). When testing MRP the whole system becomes unusable, unresponsive. Not coming from an ERP background not sure how the system should act when MRP is run. Maybe MRP puts locks everywhere (maybe the code is poorly formed) not being a programmer I am not about to begin criticising!!
Don't waste any more of your time on this issue (unless you can advise regards MRP?) maybe I should start logging using the SQL profiler then run MRP to see what happens on the SQL server. What should I look for?
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply