Viewing 15 posts - 8,386 through 8,400 (of 49,552 total)
Are you sure that it's CheckDB actually running, not SQL just reporting the last known good checkDB date?
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 20, 2014 at 2:44 pm
Intervention here someone please: http://www.sqlservercentral.com/Forums/Topic1594401-2799-1.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
July 20, 2014 at 12:03 pm
Insufficient information. The size is not what determines DR.
I suggest that you advise your boss to get someone who is familiar with implementing HA/DR in to advise, design, implement and...
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 20, 2014 at 12:00 pm
Conference done, vacation beginning.
Can some nice people please keep an eye on corruption theads and provide useful and safe advice? I might drop in occasionally to post photos, 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
July 20, 2014 at 2:56 am
May I ask why? What is the root problem you're trying to solve here?
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 19, 2014 at 7:17 am
Answer to both of those is the same. Ensure that the queries can use indexes, ensure that there are index to support the queries.
See http://www.amazon.com/Server-Query-Performance-Tuning-Experts/dp/1430242035/
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 19, 2014 at 2:53 am
Replication has no dependency on recovery models.
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 18, 2014 at 9:54 am
You should be running CheckDB regularly 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 18, 2014 at 9:15 am
You may want to call Microsoft Customer Support and open a case.
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 18, 2014 at 4:28 am
PHYData DBA (7/17/2014)
SQLRNR - Well when I mentioned that the maxdop = 1 setting is good for pure OLTP issues where the CXPACKET waits are high.
Not even then.
CXPacket...
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 17, 2014 at 8:52 am
As well as the deadlock graph, please can you post the table definitions and definitions of all the indexes on 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
July 17, 2014 at 8:46 am
Steve Jones - SSC Editor (7/16/2014)
Yes. I believe you can use copy only, which avoids this
Full backups do not break the log chain. Copy only on full backups is solely...
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 16, 2014 at 5:27 am
Edward-445599 (7/16/2014)
If I create a separate maintenance plan to do a full back up the database nightly , will this affect the log shipping.
No it won't. Full backups do...
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 16, 2014 at 5:12 am
Jeff Moden (7/15/2014)
To be honest, I'm glad this person is taking such caution and has such FUD about it.
I would be, if he were worrying in the right area,...
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 16, 2014 at 2:27 am
Steve Jones - SSC Editor (7/16/2014)
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 16, 2014 at 2:19 am
Viewing 15 posts - 8,386 through 8,400 (of 49,552 total)