Tuning areas where we need to Look
PAGEIOLATCH—DISK
CXPACKET—Big Queries
SOS_Scheduled_yield—Lots of functions may be missing Indexes
LATCH_EX—Parallelism or missing Indexes
-
Migrating a SQL Server instance involves moving databases and settings from one server to another. This process could be part of a hardware ...
-
An in-place upgrade of SQL Server involves upgrading an existing instance of SQL Server to a newer version without changing the instance na...
-
Dear Aspiring SQL DBA's , We are thrilled to share some exciting news with you! At SQL DBA Champs, we believe in the power of continuous...
-
1.First try to find the space used and empty space left in databases SET NOCOUNT ON DBCC UPDATEUSAGE(0) -- DB size. EXEC sp_spaceused ...
-
please see below on how to create backups on SQL Express edition, SQL Server express edition do not have SQL agent . 1.create a linked ...
-
Managing jobs in always on Availability groups DBA has Setup Always on Availability Groups between 2 servers and has a Scri...
-
Tuning areas where we need to Look PAGEIOLATCH—DISK CXPACKET—Big Queries SOS_Scheduled_yield—Lots of functions may be missing ...
-
declare @subject varchar(1000) set @subject = 'Space Alerts on FPVI-Xweb1' EXEC msdb.dbo.sp_send_dbmail @profile_name = 'De...
-
CAUTION, as this is going to use the error log , please make sure you test in test environment before implementing in Production. /*Cap...
-
declare @ServerName varchar(250) declare @DatabaseList varchar(4000) declare @CountMissingBackups int declare @MailSubject varchar...
About Me
Blog Archive
-
▼
2019
(14)
-
▼
December
(13)
- Find Status or percentage completed of any DBCC Sh...
- Backup databases on SQL server Express edition
- Notify if a database backup missing
- send the result of stored proceedure via email
- Send email when Blocking Happens and Track Queries
- Send email when DeadlockHappens and track Queries
- Tuning areas where we need to Look
- How licensing works with AlwaysOn Availability groups
- Find Unused databases
- Managing jobs in always on Availability groups
- Notify when SQL SERVER and Agent Restarts (works f...
- Add a new table to existing publication
- Logins, Roles and Permissions , Sysadmins
-
▼
December
(13)
Powered by Blogger.
Blog Archive
-
▼
2019
(14)
-
▼
December
(13)
- Find Status or percentage completed of any DBCC Sh...
- Backup databases on SQL server Express edition
- Notify if a database backup missing
- send the result of stored proceedure via email
- Send email when Blocking Happens and Track Queries
- Send email when DeadlockHappens and track Queries
- Tuning areas where we need to Look
- How licensing works with AlwaysOn Availability groups
- Find Unused databases
- Managing jobs in always on Availability groups
- Notify when SQL SERVER and Agent Restarts (works f...
- Add a new table to existing publication
- Logins, Roles and Permissions , Sysadmins
-
▼
December
(13)
Copyright ©
sqldbachamps | Powered by Blogger
Design by FThemes | Blogger Theme by Lasantha - PremiumBloggerTemplates.com
NewBloggerThemes.com Distributed By Gooyaabi Templates
NewBloggerThemes.com Distributed By Gooyaabi Templates
0 comments:
Post a Comment