Viewing 15 posts - 13,576 through 13,590 (of 49,552 total)
As for how you identify corruption, I answered that in the thread you started on tuning TempDB.
p.s. Please in future don't start multiple threads for the same problem, you just...
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
April 6, 2013 at 3:27 am
As per Books Online:
For per-second counters, this value is cumulative. The rate value must be calculated by sampling the value at discrete time intervals. The difference between any two successive...
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
April 6, 2013 at 3:18 am
Use the link given above, specifically the page titled "Identifying Contention on Allocation Structures Using Wait States". As stated in the other thread, allocation contention is the main reason 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
April 6, 2013 at 3:14 am
Monitor for allocation contention. That's all that multiple files and traceflag 1118 are for, if you don't have allocation contention then there's no point in adding the traceflag.
Ed's right, 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
April 6, 2013 at 3:10 am
mqbk (4/5/2013)
GilaMonster (4/5/2013)
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
April 5, 2013 at 5:45 pm
Check the SQL error log. Are you seeing recovery model changes? Do you have any other scheduled jobs that do anything to the log (including truncate it)? Do you have...
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
April 5, 2013 at 3:55 pm
Am I the only person who gets 'I don't think that's true' replies to their posts from a certain person and am I the only one annoyed by it?
I can...
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
April 5, 2013 at 2:37 pm
ScottPletcher (4/5/2013)
GilaMonster (4/5/2013)
Any data modification that is minimally logged has to be written to the data file before the transaction completes
I don't think that's true. If it is, it...
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
April 5, 2013 at 2:28 pm
They can be radically different.
For example, I worked with a card processing company a few years back, their RTO was minutes. Literally, every minute they were down they were...
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
April 5, 2013 at 1:58 pm
System tables in the master database, but no, I was not suggesting DML triggers on the system tables.
DDL triggers
http://msdn.microsoft.com/en-us/library/ms190989%28v=sql.105%29.aspx
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
April 5, 2013 at 1:05 pm
dkschill (4/5/2013)
Thanks Gail 🙂I had found that on my hunt for more information...I am actually doing a presentation on the T-LOG...
You've seen the stairway article series on that...
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
April 5, 2013 at 12:59 pm
The number of log files is irrelevant.
What, exactly, does the log backup job do? Post the sql script from it if you can.
There are two common causes of this error:...
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
April 5, 2013 at 12:58 pm
Have you considered DDL triggers?
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
April 5, 2013 at 9:38 am
If you're doing a presentation on bulk-logged, maybe there's something in here for you?
http://www.sqlservercentral.com/articles/Recovery+Model/89664/
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
April 5, 2013 at 9:38 am
sql-lover (4/5/2013)
So I wanted to open a case and review, without paying, but don't know the process or link to follow.
If you want to log a case with product support,...
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
April 5, 2013 at 9:33 am
Viewing 15 posts - 13,576 through 13,590 (of 49,552 total)