Viewing 15 posts - 31,396 through 31,410 (of 49,552 total)
balaji.ganga (8/6/2010)
4. finally you have to take the log backup.then it will reduce the log size.
No it will not! Backing up the log marks the space in the log as...
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
August 6, 2010 at 4:08 am
Stop shrinking your database! You're harming performance.
Shrinking causes massive fragmentation and will just result in the data file growing again next time data gets added. When that happens, the entire...
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
August 6, 2010 at 4:07 am
ruikong (8/5/2010)
-->in FULL recovery mode the behaviour...
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
August 6, 2010 at 4:04 am
No. Why do you think it would?
The only things that shrink a file are DBCC ShrinkDatabase, DBCC ShrinkFile and auto_shrink. Without using one of those (which is, in general, a...
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
August 6, 2010 at 3:57 am
Ratheesh.K.Nair (8/5/2010)
When u issue a check point uncommitted transaction from buffer cache are written to disk making in commited..
No.
A transaction is committed when and only when the COMMIT TRANSACTION statement...
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
August 6, 2010 at 3:55 am
Recovery model has nothing to do with performance. Recovery model has to do with how the log is reused and how you restore the database in case of a failure....
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
August 6, 2010 at 3:50 am
Jack Corbett (8/5/2010)
AHHHHHH! You said a swear word!!! Access.
There's nothing wrong with Access when used appropriately. The problem is it's seldom used appropriately.
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
August 6, 2010 at 3:44 am
The Dixie Flatline (8/5/2010)
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
August 6, 2010 at 3:42 am
azadsale (8/5/2010)
if index is created on a filegroup and that filegroup is associated with a data file.then creation date of data file=creation date of index
Incorrect, in two ways.
Files are associated...
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
August 6, 2010 at 3:25 am
You also need to do something about that transaction log. My guess - too many VLFs and too large. Would explain why recovery's taking long. See http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx for advice on...
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
August 5, 2010 at 12:15 pm
mhilligas (8/5/2010)
is_auto_close_on = 1
Turn it off. That's why the DB's repeatedly going offline.
Not sure how to check dataloss allowance
Um, that's not something that you look for in the database. That's...
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
August 5, 2010 at 12:01 pm
Yes you should, but it shouldn't be switching from online to recovering.
Is auto_close enabled?
Don't touch the log file, at least not now. What's the recovery model? What's the data loss...
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
August 5, 2010 at 11:42 am
Have you looked in Books Online? I'm pretty sure the answer is in there.
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
August 5, 2010 at 11:28 am
p.s. Is there someone there who knows SQL? If there's something wrong with this database, fixing it will get complex and technical. Will likely need someone familiar with SQL Server
p.p.s....
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
August 5, 2010 at 11:24 am
You could look in Books Online and check what the columns are. It's also pretty self-explanatory. The column is called status_desc.
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
August 5, 2010 at 11:23 am
Viewing 15 posts - 31,396 through 31,410 (of 49,552 total)