memory leak

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?
JohnLucaniaAsked:
Who is Participating?
 
Jay_Jay70Connect With a Mentor 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
0
 
Jay_Jay70Commented:
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!
0
 
Irwin SantosComputer Integration SpecialistCommented:
check to see if you have sessions that are open in your ASP pages...nothing worse than NOT closing a session down or connection.
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
JohnLucaniaAuthor 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
0
 
Jay_Jay70Commented:
reboot your server if you can
0
 
JohnLucaniaAuthor Commented:
yes, I can, but can we identify the root cause first?
0
 
Irwin SantosComputer Integration SpecialistCommented:
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.
0
 
Jay_Jay70Commented:
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...
0
 
JohnLucaniaAuthor Commented:
rebooted, but no improvement at all.
0
 
Jay_Jay70Commented:
JohnLucania,

any entried in your event viewer
0
 
JohnLucaniaAuthor 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
0
 
JohnLucaniaAuthor 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.
0
 
Jay_Jay70Commented:
0
 
JohnLucaniaAuthor 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   ........
0
 
JohnLucaniaAuthor 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...    
0
 
Jay_Jay70Commented:
you have SCSI hard disks or TAPE drive?
0
 
JohnLucaniaAuthor Commented:
It doesn't have TAPE drive.
0
 
JohnLucaniaAuthor 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?
0
 
Jay_Jay70Commented:
can you enable file and print sharing

http://support.microsoft.com/?kbid=254527
0
 
Jay_Jay70Commented:
is this a DELL server?
0
 
Jay_Jay70Commented:
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????
0
 
JohnLucaniaAuthor Commented:
Does 'file and print sharing' cause the performace issue??
0
 
JohnLucaniaAuthor Commented:
>> can you update to the lastest firmware????

What do you mean?
0
 
Jay_Jay70Commented:
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....
0
 
Jay_Jay70Commented:
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
0
 
JohnLucaniaAuthor 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
0
 
Jeff BeckhamEngineerCommented:
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
0
 
Jay_Jay70Commented:
what model server my friend?
0
 
JohnLucaniaAuthor 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
0
 
Jay_Jay70Commented:
what dell model....
0
 
JohnLucaniaAuthor Commented:
how do I check that?  The server is in a remote site...
0
 
Jay_Jay70Commented:
give someone a call   it will a be a dell poweredge or something like that
0
 
Jeff BeckhamConnect With a Mentor EngineerCommented:
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).
0
 
JohnLucaniaAuthor Commented:
Dell Poweredge 2450.
0
 
Irwin SantosConnect With a Mentor Computer Integration SpecialistCommented:
what happens when you stop the SQL service?  does the CPU process go down?
0
 
Irwin SantosComputer Integration SpecialistCommented:
cool. thank you!
0
 
Jay_Jay70Commented:
so things are ok i take it?
0
All Courses

From novice to tech pro — start learning today.