Viewing 15 posts - 4,321 through 4,335 (of 49,552 total)
SQL-DBA-01 (11/10/2015)
You can think to run extended events. Much lighter compared to Profiler.
SQL 2008 had a limited set of extended events. It wasn't until 2012 that they could entirely replace...
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
November 11, 2015 at 12:47 am
No simple answer to that. You need to consider why you're partitioning the table, where the files are, what the purpose of the multiple filegroups is and a whole lot...
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
November 10, 2015 at 1:17 pm
Steve Jones - SSC Editor (11/10/2015)
GilaMonster (11/10/2015)
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
November 10, 2015 at 10:30 am
An uncontrolled shutdown should not have caused errors. It feels like an update to the system tables was lost.
Maybe check with the storage admins that any write caches are properly...
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
November 10, 2015 at 6:38 am
I've recently seen a system with many user-defined functions, each with thousands of lines of code, often calling each other. Tests or no tests, I'm not touching 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
November 10, 2015 at 6:30 am
Depends on whether there's a witness. Is 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
November 10, 2015 at 6:27 am
No. It means that of the current plans in cache, only a few used parallelism. Depending how stable the plan cache is and when you looked at it, the plans...
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
November 10, 2015 at 4:42 am
When was the last clean checkDB on that database?
Usually this kind of error is a leftover from SQL 2000, someone deleted rows from the system tables on SQL 2000 (where...
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
November 10, 2015 at 4:39 am
Rich Mechaber (11/9/2015)
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
November 9, 2015 at 2:23 pm
andrew.leef (11/9/2015)
But we use it mostly for reporting, so generally it doesn't matter if a transaction is in process at the time.
So your users are perfectly happy getting reports 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
November 9, 2015 at 2:18 pm
Yes, the hint will override the isolation level.
Since read committed snapshot already takes no read locks, using nolock gets you all of the disadvantages of that isolation level (dirty reads,...
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
November 9, 2015 at 2:14 pm
Repeated corruption is almost always an IO subsystem problem. Not necessarily the disks, could be anything in the IO path, controllers, cache, switches, fiber cable, disks, etc, etc.
You may also...
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
November 9, 2015 at 12:32 pm
Or you could upgrade to SQL 2016 and use a TEMPORAL table. No triggers necessary. 🙂
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
November 9, 2015 at 11:43 am
http://connect.microsoft.com and file a bug. It's a preview, bugs are expected.
That said, I saw CTP 3 in use by a lot of people over the last 2 weeks, so maybe...
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
November 9, 2015 at 11:25 am
You can look at currently running queries as much as you like, but queries are not what use memory, and so you'll be wasting time looking at that.
SQL's memory usage...
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
November 9, 2015 at 11:19 am
Viewing 15 posts - 4,321 through 4,335 (of 49,552 total)