Grant Fritchey

Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Advocate in January 2011. Find Grant on Twitter @GFritchey or on his blog as the Scary DBA.

Twitter: @https://twitter.com/gfritchey
Website: https://scarydba.com
LinkedIn: https://www.linkedin.com/in/grant-fritchey/
Bluesky: https://bsky.app/profile/gfritchey.bsky.social

SSC Clinic: Finding the rogue query

by Grant Fritchey

SQLServerCentral.com

Memory

When you're getting spikes of high CPU, it's quite likely it's a rogue query. But how do you find out which query? Grant Fritchey explains, using SQL Monitor.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(18)

Log in or register to rate

You rated this post out of 5. Change rating

2012-09-13

6,257 reads

Discuss

SQL Server vs. Oracle

by Grant Fritchey

The Scary DBA

Just so we’re clear, I use SQL Server. I like SQL Server. But, this doesn’t mean I have anything against...

2012-09-07

5,022 reads

Please, Call Me Richard

by Grant Fritchey

The Scary DBA

I presented a session at the SQL Saturday event in Oklahoma City last weekend. The event itself was pretty good....

2012-08-28

1,285 reads

These People Are Exceptional

by Grant Fritchey

The Scary DBA

I should know. I was one of the judges of this year’s Exceptional DBA of the Year award. I had...

2012-08-28

1,011 reads

Another Execution Plan… In the Cloud!

by Grant Fritchey

The Scary DBA

A couple of weeks ago I posted about how different execution plans look when using the Azure Management Portal. I...

2012-08-23 (first published: 2012-08-20)

1,907 reads

24 Hours of PASS, Fall 2012

by Grant Fritchey

The Scary DBA

It’s time to get your learn on again. The schedule for the Fall 24 Hours of PASS is up and...

2012-08-22

704 reads

Coming to Your Town

by Grant Fritchey

The Scary DBA

I can’t sing and I can’t play and I left the young generation behind a while ago, but I’m still...

2012-08-16

1,173 reads

Being Right, the Other Side

by Grant Fritchey

The Scary DBA

I read an excellent article by Camille Fournier about the importance of recognizing that being right is not the only...

2012-08-15

846 reads

Execution Plans … In the Cloud!

by Grant Fritchey

The Scary DBA

If you’re moving to a fully-fledged SQL database as part of Azure you may never even touch SQL Server Management...

2012-08-10 (first published: 2012-08-01)

2,735 reads

SQL In The City: London 2012, Recap

by Grant Fritchey

The Scary DBA

Wow!
How’s that for a recap?
The concept for the SQL in the City events is pretty simple. Put on a free...

2012-07-17 (first published: 2012-07-16)

2,090 reads

Blogs

Microsoft Tools for Making Data AI-Ready

Making Data AI-Ready, Part 2 (This is the second article in a three-part series...

Local Models Using GPUs with Ollama

Can you use your GPUs when running a local model under Ollama? You can,...

Don’t Fear the Technology

By Brian Kelley

The concern that a particular technology is going to destroy the world seems to...

Read the latest Blogs

Forums

RegEx Functions III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item RegEx Functions III

Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix

Comments posted to this topic are about the item Optimized Locking in SQL Server...

Finely Tuned Models

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finely Tuned Models

Visit the forum

Question of the Day

RegEx Functions III

If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.

See possible answers