Viewing 15 posts - 25,186 through 25,200 (of 49,552 total)
Long running uncommitted transaction is the typical reason.
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
July 5, 2011 at 5:33 am
Jayanth_Kurup (7/5/2011)
Also, i wasn't able to find anything that says checkpoint is a scheduled operation , msdn says its event based.
It's not scheduled. It runs when SQL decides to...
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
July 5, 2011 at 4:14 am
Checkpoint runs periodically anyway.
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
July 5, 2011 at 3:41 am
Why do you consider it a problem?
Did you search the MS kb articles as I suggested? Or look through recently installed updates? You've got the KB number (KB2494120) so go...
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
July 5, 2011 at 3:40 am
There is. I can't recall off the top of my head, but there's a traceflag that, when enabled, makes SQL only recover the master database, not model or tempDB. With...
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
July 5, 2011 at 3:10 am
gsuvarnarekha (7/4/2011)
How to check whether sql profiler is enable or not ..and reqired complete steps regarding creating trace and all for enabling the sql profiler
Profiler's not something you enable. It'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
July 5, 2011 at 3:09 am
Yes, that's what I'm saying. Windows update could have applied a SQL patch hence upping the version. Did you check? Also check the MS kb articles for that build number.
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
July 5, 2011 at 3:08 am
ALZDBA (7/5/2011)
SQLkiwi (7/4/2011)
ALZDBA (7/4/2011)
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
July 5, 2011 at 3:05 am
http://www.brentozar.com/archive/2009/04/how-to-get-a-junior-dba-job-part-1/
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
July 5, 2011 at 2:50 am
Windows update? There have been a couple patches lately.
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
July 5, 2011 at 2:44 am
mohammed moinudheen (7/4/2011)
Thank you Gail, this was tough. Not like last week's question :-).
See, that was just a warmup. 🙂
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
July 5, 2011 at 2:35 am
Yup. It's called restart recovery. It'll be slower than necessary if you have excessive VLFs. There are several posts on Kimberly Tripp's blog on that (google to find them, I...
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
July 5, 2011 at 2:35 am
CELKO (7/4/2011)
(@in_emp_id INTEGER, @in_emp_name VARCHAR(35),
@in_emp_dept_nbr INTEGER, @in_emp_loc INTEGER)
AS
SELECT emp_id, emp_name, emp_dept_nbr, emp_loc
FROM Personnel
WHERE emp_id = COALESCE (@in_emp_id, emp_id)
AND emp_name LIKE...
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
July 5, 2011 at 2:23 am
Edit: Blah
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
July 5, 2011 at 2:21 am
Craig Farrell (7/4/2011)
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
July 4, 2011 at 4:55 pm
Viewing 15 posts - 25,186 through 25,200 (of 49,552 total)