Viewing 15 posts - 1,051 through 1,065 (of 49,552 total)
Shameless self-promotion:
https://www.pluralsight.com/courses/solving-real-world-problems-sql-server-2016-query-store
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 27, 2017 at 1:46 am
CheckDB with repair (any repair) WILL NOT fix these errors, so please don't suggest it.
You probably do have some IO subsystem problems, as that's the main cause of corruption,...
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 26, 2017 at 1:38 pm
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 26, 2017 at 12:56 pm
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 26, 2017 at 12:55 pm
Someone restarted the server and deleted old error logs?
If that was my server, I'd be talking it IT security at this point, as it smells like someone's trying...
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 26, 2017 at 1:19 am
All my home machines have names out of Arthurian stories.
Desktop: Myrlin (and new desktops get the same name)
Server: Old server was Camelot, when I got a new...
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 25, 2017 at 7:03 am
GA_SQL - Tuesday, July 25, 2017 5:03 AMAny Script to do past 2 weeks monitoring, please suggest
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 25, 2017 at 5:49 am
You can look in the default trace. It rolls over though, so doesn't go back very far.
Other than that, you need custom monitoring (not CDC, that's for data)
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 25, 2017 at 4:06 am
How does an error log get truncated?
Unless you've messed with the default settings, it should contain 6 older logs and the current one, and the recovery pending messages...
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 25, 2017 at 4:01 am
Before you restart, what messages are there related to the DB in the error log?
There will be messages in the error log saying why the DB couldn't recover. Always...
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 25, 2017 at 3:06 am
So in which case I can get a standard /enterprise edition...
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 25, 2017 at 1:20 am
You don't really need the explicit transaction. A single statement is its own transaction, and since there's no error handling, there's no real gain from explicitly declaring a transaction. 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
We stand on the bridge and no one may pass
July 24, 2017 at 2:00 pm
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 24, 2017 at 1:42 pm
No, serialisable doesn't force exclusive locks or table-level locks.
The isolation levels mostly change how read queries behave, not data modifications
You get a upd lock, on whatever...
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 24, 2017 at 1:19 pm
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 24, 2017 at 12:42 pm
Viewing 15 posts - 1,051 through 1,065 (of 49,552 total)