神刀安全网

We’re Renaming sp_AskBrent. What Should the New Name Be?

Yesterday we announced that we’re open sourcing our free SQL Server scripts , and one of those is sp_AskBrent. I originally named it that because it had a funny magic-8-ball type feature: if you pass in a question as a parameter, it gives you an answer:

We’re Renaming sp_AskBrent. What Should the New Name Be?

sp_AskBrent @Humor = 1

Cute, but now that it’s open source, it’s time to give it a name that matches the important stuff it does.

Here’s what sp_AskBrent does:

sp_AskBrent with no parameters gives you a prioritized list of reasons why your SQL Server is slow right now, like a backup running, rollback happening, a data or log file growing, a long-running query blocking others, extremely high CPU use, etc.

sp_AskBrent @SinceStartup = 1 shows your wait types, file stats, and Perfmon counter activity since startup.

sp_AskBrent @OutputDatabaseName = ‘DBAtools’, @OutputSchemaName = ‘dbo’, @OutputTableName = ‘AskBrentResults’ – plus a few other parameters – captures your wait types, file stats, and Perfmon counters into a table so you can do your own performance trending over time.

So what should we name it?

Most of our other tools start with sp_Blitz, so maybe sp_BlitzPerformanceCheck or sp_BlitzMetrics. I have no idea. But I bet you do, so put in your comments here before end of day on Friday, June 24th, 2016. We’ll pick a winner based on completely random subjective taste, and the first person who suggested that name will get a freeEverything Bundle. Good luck!

Tara says:I like sp_BlitzNow. Vote for my pick, and I’ll send you some Brent Ozar Unlimited magnets. I’m kidding. Those things are heavy. Shipping will mean I can’t pay the mortgage. If my pick wins, I’ll give away the Everything Bundle to a random person that commented.

We’re Renaming sp_AskBrent. What Should the New Name Be?

I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.

I’m mostly a figurehead here at Brent Ozar Unlimited. My true skills are menu advice, interpretive dance, and reading Wikipedia.

We’re Renaming sp_AskBrent. What Should the New Name Be? We’re Renaming sp_AskBrent. What Should the New Name Be? We’re Renaming sp_AskBrent. What Should the New Name Be? We’re Renaming sp_AskBrent. What Should the New Name Be? We’re Renaming sp_AskBrent. What Should the New Name Be?

转载本站任何文章请注明:转载至神刀安全网,谢谢神刀安全网 » We’re Renaming sp_AskBrent. What Should the New Name Be?

分享到:更多 ()

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址