Forum Replies Created
Viewing 15 posts - 526 through 540 (of 49,552 total)
-
RE: Splitting TempDB across multiple files
Jeff Moden - Tuesday, January 2, 2018 6:19 AMGail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: Extended Events captures query_hash/query_plan_hash to 0 in some queries
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: Extended Events captures query_hash/query_plan_hash to 0 in some queries
Try adding sp_statement_completed event.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: Extended Events captures query_hash/query_plan_hash to 0 in some queries
It's an EXEC statement. The only things that have query hashes are the queries themselves, not exec of stored procedures (which this is)
Since you're capturing statement completed, 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: footprinting a database
If the DB doesn't have constraints, finding the columns they should be on will likely be the least of the problems. Fixing the data so that constraints can be added...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: SQL Server 2017 not setting affinity for all processors in system
Please do. I'd like to see some snapshots of the schedulers DMV under load.
Are you monitoring wait stats? If not, can you also take snapshots of sys.dm_os_wait_stats while...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: SQL Server 2017 not setting affinity for all processors in system
Ok, I suspect what you're seeing is not SQL not using the other processors, but a side effect of how affinity is set on higher processors. Your observation that all...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: Insert Into Where NOT Exists
Lynn Pettis - Friday, December 29, 2017 2:14 PM
