Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Time out the SPID - Unknown,Autogrow of file? Expand / Collapse
Author
Message
Posted Wednesday, October 16, 2013 6:52 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:56 PM
Points: 1,015, Visits: 2,840
Hi.

Version - SQL Server 2008 standard edition with SP1.

Database File setting as follows

MDF file growth 1 MB unrestricted growth
LDF file growth restricted file growth up to 2TB (by default SQL values)

Even though I am facing problem some of the transaction not completed and information available at error log file

10/16/2013 14:34:57,spid63,Unknown,Autogrow of file 'databasename_log' in database ''databasename' was cancelled by user or timed out after 47 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.

Pl. suggestion me what could be issues, why that tracsaction accouping upto 2TB?

After that I have changed data & log file setting

MDF file growth 100 MB unrestricted growth
LDF file growth restricted file growth up to 30GB

Thanks
ananda


Post #1505165
Posted Wednesday, October 16, 2013 7:08 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
Is the log drive being used by other things too like tempdb or data files ?

And what was the initiall size of this log file ? and have you set the percent growth or MB growth and how much ?


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1505173
Posted Wednesday, October 16, 2013 10:15 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:56 PM
Points: 1,015, Visits: 2,840
Bhuvnesh (10/16/2013)
Is the log drive being used by other things too like tempdb or data files ?

And what was the initiall size of this log file ? and have you set the percent growth or MB growth and how much ?


that database log file growth 50 MB and initial size is 30 MB.


Yes, Instance have multiple database available and also all database data and log file located same "D" drive.

Tempdb location another drive in C drive..
Post #1505477
Posted Thursday, October 17, 2013 3:19 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
ananda.murugesan (10/16/2013)
Yes, Instance have multiple database available and also all database data and log file located same "D" drive.

Tempdb location another drive in C drive..
This could be reason.

ALTEAST try to place Log files on another (separate) drive and TempDB on another too.

IS it a Dev server ? and what the total D drive disk ?


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1505550
Posted Thursday, October 17, 2013 4:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:56 PM
Points: 1,015, Visits: 2,840
Bhuvnesh (10/17/2013)
ananda.murugesan (10/16/2013)
Yes, Instance have multiple database available and also all database data and log file located same "D" drive.

Tempdb location another drive in C drive..
This could be reason.

ALTEAST try to place Log files on another (separate) drive and TempDB on another too.

IS it a Dev server ? and what the total D drive disk ?


It is production server.. all the partition in RAID 5

There is no meaning data file and log file placed on different dirve if server HW have single array controller..
Post #1505572
Posted Thursday, October 17, 2013 4:35 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
ananda.murugesan (10/17/2013)
It is production server.. all the partition in RAID 5
There is no meaning data file and log file placed on different dirve if server HW have single array controller..
I wasnt aware of RAID .


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1505581
Posted Thursday, October 17, 2013 4:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:56 PM
Points: 1,015, Visits: 2,840

Due to that error AUTO SHIRNK enabled on that database..after disabled error was not appear in log file during transactions..

also log file inital size 1 GB and allow gorwth upto 30GB and growth increment 25MB..

Post #1505590
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse