We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

memory leak

JohnLucania
JohnLucania asked
on
Medium Priority
572 Views
Last Modified: 2010-05-18
WIN2K server is running very slow.  
I am seeing:
sqlservr.exe takes 430,000 K (CPU Time: 21:24:00)
jrun.exe 92,236 K (CPU Time: 19:30:00)

Would they be the cause of the slowness?  or something else?
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2006

Commented:
Hi JohnLucania,

has this problem been happening for a while? how often do you restart your server, sql does run fairly heavily but the CPU time looks slightly dicey....

Cheers!
Irwin SantosComputer Integration Specialist

Commented:
check to see if you have sessions that are open in your ASP pages...nothing worse than NOT closing a session down or connection.

Author

Commented:
>> has this problem been happening for a while?
It is from yesterday.

>> how often do you restart your server
not quite often

>> check to see if you have sessions that are open in your ASP pages...
all closed
CERTIFIED EXPERT
Top Expert 2006

Commented:
reboot your server if you can

Author

Commented:
yes, I can, but can we identify the root cause first?
Irwin SantosComputer Integration Specialist

Commented:
probably the best is to reboot... but before you do that, take notice of the event viewer in applications/security...etc...  When the system restarts.. note the services that you have running and the current process.
CERTIFIED EXPERT
Top Expert 2006

Commented:
often a application can "hang" without actually haninging if that makes sense

its one of the reasons people prefer linux becoz of the instability of windows - this is one of the exact cases of this "instability" often there can be thousands of possibilities as to why these proccesses crash yet you often cant narrow them down...

Author

Commented:
rebooted, but no improvement at all.
CERTIFIED EXPERT
Top Expert 2006

Commented:
JohnLucania,

any entried in your event viewer

Author

Commented:
Event Type:      Warning
Event Source:      WinMgmt
Event Category:      None
Event ID:      61
Date:            3/30/2006
Time:            10:48:55 PM
User:            N/A
Computer:      SUNFISH
Description:
WMI ADAP was unable to process the PerfProc performance library due to a time violation in the collect function

Author

Commented:
Event Type:      Warning
Event Source:      MSSQLServer
Event Category:      (8)
Event ID:      19011
Date:            3/30/2006
Time:            10:46:58 PM
User:            N/A
Computer:      SUNFISH
Description:
SuperSocket info: (SpnRegister) : Error 1355.
CERTIFIED EXPERT
Top Expert 2006

Commented:

Author

Commented:
Event Type:      Warning
Event Source:      perc2
Event Category:      None
Event ID:      26
Date:            3/30/2006
Time:            10:46:14 PM
User:            N/A
Computer:      SUNFISH
Description:
The driver has detected that device \Device\Scsi\perc21 has old or out-of-date firmware. Reduced performance may result.
Data:
0000: 0f 00 10 00 01 00 64 00   ......d.
0008: 00 00 00 00 1a 00 04 80   .......€
0010: 54 07 00 00 00 00 00 00   T.......
0018: 00 00 00 00 00 00 00 00   ........
0020: 00 00 00 00 00 00 00 00   ........
0028: 00 00 00 00 00 00 00 00   ........
0030: 00 00 00 00 09 00 00 00   ........

Author

Commented:
Event Type:      Error
Event Source:      BROWSER
Event Category:      None
Event ID:      8032
Date:            3/30/2006
Time:            8:47:16 PM
User:            N/A
Computer:      SUNFISH
Description:
The browser service has failed to retrieve the backup list too many times on transport \Device\NetBT_Tcpip_{776D9B0B-7623-42DD-BC2A-63EB8DE2B842}. The backup browser is stopping.
Data:
0000: 47 00 00 00               G...    
CERTIFIED EXPERT
Top Expert 2006

Commented:
you have SCSI hard disks or TAPE drive?

Author

Commented:
It doesn't have TAPE drive.

Author

Commented:
ok, "This message is not an error message".

When SQL Server starts on a computer that is running Microsoft SQL Server 2000 or Microsoft SQL Server 2005, the SQL Server program always attempts to register the virtual server in the Active Directory. You may see the following warning in the Microsoft Windows NT event log:
Warning SuperSocket Info: (SPNRegister) : Error 1355
Event Category 8
Event ID 19011
This message is not an error message. This text is only a warning that SQL Server was not able to register a Service Principal Name (SPN), which indicates that the security mechanism that will be used is Microsoft Windows NT Challenge\Response (NTLM) authentication instead of Kerberos.

then, what else?
CERTIFIED EXPERT
Top Expert 2006

Commented:
can you enable file and print sharing

http://support.microsoft.com/?kbid=254527
CERTIFIED EXPERT
Top Expert 2006

Commented:
is this a DELL server?
CERTIFIED EXPERT
Top Expert 2006

Commented:
From a newsgroup post: "In the past we saw several problems between old firmware of Dell Perc Raid controller and I/O intensive apps like VSS. The machines would contain event logs such as this one. Please make sure that your controller has the latest firmware".  

can you update to the lastest firmware????

Author

Commented:
Does 'file and print sharing' cause the performace issue??

Author

Commented:
>> can you update to the lastest firmware????

What do you mean?
CERTIFIED EXPERT
Top Expert 2006

Commented:
im trying to nail down those event log errors so that we can clear up what IS causing the performance errors    my guess is the firmware update myself but i could be wrong....
CERTIFIED EXPERT
Top Expert 2006

Commented:
well what is the model of your SCSI controller?    ill see if there is a firmware update available

firmware is the mean os of communicating between the software and hardware

Author

Commented:
C: is DELL Container SCSI Disk

SCSI and RAID Controllers
Adptec AIC-7899 Ultra160/m PCI SCSI Card
Dell PERC 3 RAID (SCSI Chip)
Dell PERC 3/Si RAID Controller
Jeff BeckhamEngineer
CERTIFIED EXPERT

Commented:
How much physical memory is in the server and how much physical memory is available (for a quick read on physical available, go to Task Manager, Performance tab, check the Physical Memory (K) text box, see Available)?  How much free free disk space is on the drive with the OS?  What other network services does the server provide?

I'm guessing that you're low on memory/disk space and it's causing your server performance to drop significantly.

See "How to adjust memory usage by using configuration options in SQL Server": http://support.microsoft.com/default.aspx?scid=kb;en-us;321363
CERTIFIED EXPERT
Top Expert 2006

Commented:
what model server my friend?

Author

Commented:
Physical Memory (K)

Total: 1,048,104
Avail: 590,000
System cache: 403,000

C: totlal 25 GB; 10 GB free

x86 Family 6 Model 8 Stepping
3
AT/AT compatible

Windows 2000 SP 4  5.00.2195
CERTIFIED EXPERT
Top Expert 2006

Commented:
what dell model....

Author

Commented:
how do I check that?  The server is in a remote site...
CERTIFIED EXPERT
Top Expert 2006

Commented:
give someone a call   it will a be a dell poweredge or something like that
Jeff BeckhamEngineer
CERTIFIED EXPERT
Commented:
Please define "running very slow" (i.e., slow GUI from the console, slow response over the network, etc.).

What's the processor doing (i.e., is it showing high utilitization in Task Manager)?  How about network response.  If you ping it from your remote machine, are the replies coming back with normal response times?  Are you seeing any dropped packets ("ping w.x.y.z. -t" for continuous ping).

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Dell Poweredge 2450.
Irwin SantosComputer Integration Specialist
Commented:
what happens when you stop the SQL service?  does the CPU process go down?
CERTIFIED EXPERT
Top Expert 2006
Commented:
if your hard disks or SCSI controllers are giving errors like they are, the you all round performance WILL be affected   im not saying this is the problem you are having but its proccess of elimination

check this
http://support.dell.com/support/downloads/format.aspx?c=us&l=en&s=gen&SystemID=PWE_PNT_P3C_2450&os=WNET&osl=en&deviceid=1374&typecnt=3&releaseid=R105808&vercnt=9

and driver side
http://support.dell.com/support/downloads/format.aspx?c=us&l=en&s=gen&SystemID=PWE_PNT_P3C_2450&os=WNET&osl=en&deviceid=1374&typecnt=3&releaseid=R74084&vercnt=3
Irwin SantosComputer Integration Specialist

Commented:
cool. thank you!
CERTIFIED EXPERT
Top Expert 2006

Commented:
so things are ok i take it?
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.