Viewing 15 posts - 5,836 through 5,850 (of 49,552 total)
Grant Fritchey (5/21/2015)
They have not been given enough love by Microsoft, so you're going to struggle to get them to work correctly. However, once you do, they really are terrific.
Tell...
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
May 21, 2015 at 9:46 am
Brandie Tarvin (5/21/2015)
Has anyone installed the Distributed Replay components?
Yes, several times.
Have they helped? Have they hurt?
Are they even useful or is it just another MS component that potentially...
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
May 21, 2015 at 9:45 am
Grant Fritchey (5/21/2015)
Anti-virus
VM configuration
Server configuration (no NOT memory, I suspect something CPU related)
Queries that have always caused pain but...
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
May 21, 2015 at 9:41 am
Edit..
Looks OK. What is telling you it's wrong?
VM Committed 1061976
1061976 kB = 1037 MB, which is close enough to 1024 to be rounding or a 1000/1024 division issue.
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
May 21, 2015 at 9:35 am
In that case: http://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput/
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
May 21, 2015 at 9:11 am
I checked MSDB, there are no missing backups
2 hours later
There's a problem, the query on MSDB showed a transaction log backup that's missing.
Hmmm. Or is this quantum backups, it's both...
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
May 21, 2015 at 9:07 am
Greg Edwards-268690 (5/21/2015)
Have you ever seen I/O contention lead to high CPU usage?
I have, but you tend to see it in the wait stats and the perfmon counters. High CPU,...
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
May 21, 2015 at 9:04 am
jitendra.padhiyar (5/21/2015)
one more Tlog backup at 10.12 PM
There's your problem.
The full's fine, but a missing log backup will mean that you can't restore past that point. So unless you...
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
May 21, 2015 at 9:02 am
No, SSMS is not going to be the cause of SQL Server telling you that the log chain is broken.
What does MSDB show?
What are your restore statements?
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
May 21, 2015 at 7:13 am
You can edit the script if you want them that way. SSMS scripts constraints separately to the table. Doesn't make much of a difference.
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
May 21, 2015 at 7:01 am
TheSQLGuru (5/21/2015)
I will also add that I have seen this only 3 times in the wild in my almost 20 years of working/consulting on SQL Server
I've seen TempDB allocation page...
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
May 21, 2015 at 6:43 am
Reducing contention on the allocation pages. That's the whole reason why TempDB gets split. It's why that old recommendation of 'files = cores' came about in the first place.
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
May 21, 2015 at 6:31 am
Why do they think it's corrupt? Is there any justification there?
Check the MSDB backup takes, see what backups were taken, compare that with the backups you have, see if 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
May 21, 2015 at 6:20 am
My usual recommendation to clients is:
Split TempDB into 4 files, make sure they're all the same size, all the same growth increment. If I'm seeing obvious allocation contention 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
May 21, 2015 at 6:16 am
You can mark a view as system, but it won't result in the data being persisted to disk. The correct answer is 'A', google 'Indexed Views' for further details.
ColumnStore indexes,...
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
May 21, 2015 at 4:13 am
Viewing 15 posts - 5,836 through 5,850 (of 49,552 total)