Work History
Education
Timeline
Generic

KEVIN CAUDLE

WALDORF,MD

Work History

  • Sp_whoisactive, SP_WHo2
  • Show me all the processes running on my database 1
  • Do we have a long running query 2
  • Blocking Session 3
  • Waits Stats: shows the performance issues that sql server is facing.
  • CXPACKEt: parallel
  • Tweak/modify your MAXDOP—Maximum degree of parallelism and cost threshold you can set this at the instance level or you can set it at the query level
  • PageIOlatch: (IO : input /output operation)
  • There is a problem with your IO subsystem
  • It could be an indication of High disk latency/ Slow disk
  • You are doing more physical reads than logical reads
  • That you do not have the right kind of index 3
  • LCK: blocking issues: ( investigate the query and your indexes) 4
  • HADR: it could be an indication of slowness between you replicas ( ` 1
  • Investigate network latency , 2
  • Change the availability mode from synchronous commit to asynchronous commit
  • Second Part
  • Investigate / look into/ narrow down to top resource consuming queries on the server
  • You look at the execution plan
  • Slow RUnning Query - Execution Plan Actual Estimated ==
  • Cost Distribution operation that is happening around 1
  • Table Scan..
  • Sol : create an index 2
  • Keylook up 3
  • Rid Look up 4
  • Index Scan 2-4: there are indexes on the table, but the index is not sufficient to satisfy the requirement of the query so sql server is doing scanning look up activity which in some cases can be expensive.
  • Sol: 1
  • You can create or modify existing indexes and also use the include statement to create a covered index, 5
  • Implicit conversion: 1
  • Varchar = int int = varchar 1
  • Introduce cast function on your query to help with the conversion 2
  • Change the data type to what it should be 6
  • Fragmented/Fragmentation.
  • DML: Data Manipulation Language
  • Select,Insert, Update and delete
  • Defragment Reorganize 5 rebuild Offline / Online - Drop and recreate that index...
  • Stats update 3rd Party
  • Stats Update
  • Index Fragmentation
  • Query Store:
  • Top resource consuming query
  • Regressed query Execution Plan
  • You can use it to for execution plan 4th
  • Extended events
  • Profiler session to capture traces.
  • Database engine tuning advisor
  • Creates index, create stats, update stats

Education

Computer Science -

Career Technical Institute
Washington, DC
08.2024

Timeline

Computer Science -

Career Technical Institute

Similar Profiles

CREATE PROFILE
KEVIN CAUDLE