September 18, 2008 at 11:39 pm
hi all,
we have sql server 2005, from last 15-20 days dump files are getting created suddenly in log folder, m not able to find any solution as to how it is being created. dump files are very heavy and its being created every 2 min. it includes .txt, .log, .mdmp files.
Thanks in advance,
Vinit Fichadia
September 19, 2008 at 12:39 am
What version are you on
Select Serverproperty( 'BuildClrVersion' ) as BuildClrVersion
, Serverproperty( 'Collation' ) as Collation
, Serverproperty( 'CollationID' ) as CollationID
, Serverproperty( 'ComparisonStyle' ) as ComparisonStyle
, Serverproperty( 'ComputerNamePhysicalNetBIOS' ) as ComputerNamePhysicalNetBIOS
, Serverproperty( 'Edition' ) as Edition
, Serverproperty( 'EditionID' ) as EditionID
, Serverproperty( 'EngineEdition' ) as EngineEdition
, Serverproperty( 'InstanceName' ) as InstanceName
, Serverproperty( 'IsClustered' ) as IsClustered
, Serverproperty( 'IsFullTextInstalled' ) as IsFullTextInstalled
, Serverproperty( 'IsIntegratedSecurityOnly' ) as IsIntegratedSecurityOnly
, Serverproperty( 'IsSingleUser' ) as IsSingleUser
, Serverproperty( 'LCID' ) as LCID
, Serverproperty( 'LicenseType' ) as LicenseType
, Serverproperty( 'MachineName' ) as MachineName
, Serverproperty( 'NumLicenses' ) as NumLicenses
, Serverproperty( 'ProcessID' ) as ProcessID
, Serverproperty( 'ProductVersion' ) as ProductVersion
, Serverproperty( 'ProductLevel' ) as ProductLevel
, Serverproperty( 'ResourceLastUpdateDateTime' ) as ResourceLastUpdateDateTime
, Serverproperty( 'ResourceVersion' ) as ResourceVersion
, Serverproperty( 'ServerName' ) as ServerName
, Serverproperty( 'SqlCharSet' ) as SqlCharSet
, Serverproperty( 'SqlCharSetName' ) as SqlCharSetName
, Serverproperty( 'SqlSortOrder' ) as SqlSortOrder
, Serverproperty( 'SqlSortOrderName' ) as SqlSortOrderName
- Is your sqlserver instance crashing ?
- are there CLR modules causing these crashes ?
- at it sqlagent jobs casing these crashes ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 19, 2008 at 1:53 am
You may want to contact Microsoft's customer support people on this. Stack dumps shouldn't be occurring at all, much less every couple min. They will have the tools to read the stack dumps and figure out the root cause. We don't have access to the same tools.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply