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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.94 (18)

Log in or register to rate

You rated this post out of 5. Change rating

2012-09-13

6,228 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,012 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,279 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,005 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,896 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

687 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,166 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

840 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,718 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,085 reads

Blogs

Scaling PowerShell – Lessons from a Technical Interview

Recently, I was in a technical interview where the topic of running PowerShell at...

Installing Old Versions of PowerShell Modules with Their Dependencies

I don’t recall where this came up (probably in SQLSlack), but I had a...

In Memory of Andrew Clarke, AKA Phil Factor

One of the parts of getting older that really sucks is I seem to...

Read the latest Blogs

Forums

how to get notification that my database has corssed 8gb

By rajemessage 14195

i have sqlexpress on rds, is there any way i can get notifacation that...

SQL Server, Heaps and Fragmentation

Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation

Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained

By Chandan Shukla

Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...

Visit the forum

Question of the Day

SQL Server, Heaps and Fragmentation

A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?

See possible answers