Skip to content

Igor Micev

My blog about SQL Server

Menu

Primary menu

  • Blog
  • About Me

Tag Archives: jobs

CPU Spikes Caused by Periodic Scheduled Jobs

Posted on December 1, 2016 by Igor Micev — No Comments ↓

In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs that execute periodically. Figure 1 shows such a situation. You can see the spikes occurring every minute. Figure 1. CPU Continue reading CPU Spikes Caused by Periodic Scheduled Jobs→

Posted in Maintenance | Tagged jobs | Leave a reply

Primary Sidebar Widget Area

Recent Posts

  • Useful T-SQL queries and scripts to work in SQL Server
  • How to Write a Better T-SQL Code
  • Some New Cool Features in SSMS

Categories

  • .NET (3)
  • Configuration (6)
  • Database design (5)
  • Features (4)
  • Installation (4)
  • Maintenance (7)
  • Optimization (5)
  • Programming (5)
  • Scripts (4)
  • SQL Server (2)
  • SSMS (6)
  • T-SQL (13)
  • Technology (2)
  • Uncategorized (6)

Tags

C# clone CLR code-refactoring compression configuration constraints cpu CXPACKET dates EOMONTH extents foreign keys fragmentation functions hints and tips indexes JASON jobs jokes licensing master rebuild maxdop MCT mixed_page_allocation MVP powershell primary key query Regex reports report server sample databases script snapshot SQL Azure sql server ports stored procedures system databases tempdb temp tables

Subscribe via Email

Subscribe via Email

  • Twitter
  • Google Plus
  • Linkedin
  • RSS Feed
Copyright © 2023 Igor Micev. All Rights Reserved.
Theme: Catch Box by Catch Themes
Scroll Up