memory leak

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!

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

>> 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

reboot your server if you can

yes, I can, but can we identify the root cause first?

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.

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...

rebooted, but no improvement at all.

JohnLucania,

any entried in your event viewer

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

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.

have a read of this

http://support.microsoft.com/kb/303411

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   ........

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...    

you have SCSI hard disks or TAPE drive?

It doesn't have TAPE drive.

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?

can you enable file and print sharing

http://support.microsoft.com/?kbid=254527

is this a DELL server?

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????

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

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

What do you mean?

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....

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

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

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

what model server my friend?

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

what dell model....

how do I check that?  The server is in a remote site...

give someone a call   it will a be a dell poweredge or something like that

Dell Poweredge 2450.

cool. thank you!

so things are ok i take it?