SQL Server 2014 Health check DMV queries Day 3


Hi guys in the Previous post i explained How we can get the Server Properties , returning SQL Server Agent Job Information put today and How we can return SQL Server Agent Alert Information put today in DAY 3 i will show new DMV in our track Instance Level configuration

DMV#6 Global Trace Flag Information
Very useful to know what global trace flags are currently enabled as part of the diagnostic process if not trace flag enable it will not return any thing for more information about trace flag look Here

DBCC TRACESTATUS (-1);

DMV#7 Getting Information About Windows

by the below DMV we can return the major OS version, Service Pack, Edition, and language info for the operating system

SELECT windows_release, windows_service_pack_level,
windows_sku, os_language_version
FROM sys.dm_os_windows_info WITH (NOLOCK) OPTION (RECOMPILE);

DMV#8SQL Server Services Information

by the below DMV we can return very important information like this instance is clustered or No , processid , when they were last started, and their current status , the start up type of the SQL server services and SQL server agent services .

SELECT servicename, process_id, startup_type_desc, status_desc,
last_startup_time, service_account, is_clustered, cluster_nodename, [filename]
FROM sys.dm_server_services WITH (NOLOCK) OPTION (RECOMPILE);

SQL Server Services Information
SQL Server Services Information

To check all my posts you can direct to my personal website or you can download this Excel sheet My Technical POSTS

View all my tips , LinkedIn Website Slideshare ,Youtube Channel

SQL Server 2014 Health check DMV queries Day 2


images (1)

Hi guys in the Previous post i explained How we can get the SQL Server instance version and How we can know the installed date for SQL Server instance put today is DAY 2 and i will show new DMV in our track Instance Level configuration Queries

DMV#3 Server Properties

below DMV is more helpful and useful this DMV This gives you a lot of useful information about your instance of SQL Server like (Computer name , ProcessID , SQL Server collation  , Product level…etc)

DMV#4 SQL Server Agent Job Information

below DMV it will return for us basic information about SQl Server agent and the user name configure it to review it one by one.

DMV#5 SQL Server Agent Alert Information 

by the below DMV we will return the basic information about SQL Server agent alerts

Check the Full posts and the scripts : http://sqlserver-performance-tuning.net/?p=5924

To check all my posts you can direct to my personal website or you can download this Excel sheet My Technical POSTS

View all my tips , LinkedIn Website Slideshare ,Youtube Channel.

SQL Server 2014 Health check DMV queries Day 1


Hello Guys Follow Me from today and over the next 30 days i will share with in this 30 days 70 DMV each day we will have at least 2 new DMV this DMV Library used for healthy check in SQL Server 2014 and it covered 3 tracks (Instance configuration , instance Performance , Database Performance) Follow Us and here is the day number one : (SQL Server 2014 Health check DMV queries Day 1)

http://sqlserver-performance-tuning.net/?p=5901

Health check DMV queries
Health check DMV queries

To check all my posts you can direct to my personal website or you can download this Excel sheet My Technical POSTS

View all my tips , LinkedIn Website Slideshare ,Youtube Channel.

SQL Server 2014 Service Pack 1 has released


Congratulation Microsoft and big Congratulation for us (SQL Server Releases blog)

sql-server-2014-logo

One year ago, Microsoft launched SQL Server 2014. Today, April 15, Microsoft are pleased to announce the release of SQL Server 2014 Service Pack 1 (SP1). The Service Pack will be available for download on the Microsoft Download Center.

SQL Server 2014 SP1 contains fixes provided in SQL Server 2014 CU 1 up to and including CU 5, as well as a rollup of fixes previously shipped in SQL Server 2012 SP2. For highlights of the release, please read the Knowledge Base Article for Microsoft SQL Server 2014 SP1.

As part of our continued commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2014 deployments via the download links below. SQL Server 2014 with SP1 will be available in additional venues including the Volume Licensing Center and via Microsoft Update starting May 1, 2015.

Microsoft® SQL Server® 2014 SP1
Microsoft® SQL Server® 2014 SP1 Express
Microsoft® SQL Server® 2014 SP1 Feature Pack

To check all my posts you can direct to my personal website or you can download this Excel sheet My Technical POSTS

View all my tips , LinkedIn Website Slideshare ,Youtube Channel.

How to build , Manage and monitor your SQL Server replication


Hello my friends this my small post in SQL Server replication it is not everything about replication but at least it is the what any DBA should know it 11 Posts in SQL Server replication technology english and arabic posts

  • What is SQL Replication?
  • Types of SQL Replication
  • Replication Overview
  •  How to create Transaction Replication
  • How to Add New Publisher Server to the Distributor Server
  •  Disable Publishing and Distribution Servers
  • Publication Status
  • Subscription Status
  • Replication information for the Complete setup
  • Find publication article
  • How we can Check Distributor agent status
  • How we can Check log reader agent status

downloadreplica

All this previous point you can know it easily from the below Posts :

  1. Replication in SQL Server Part 1
  2. Replication in SQL Server Part 2
  3. Replication in SQL Server Part 3
  4. Replication in SQL Server Part 4
  5. SQL Server DMV Replication Monitoring Part 1
  6. SQL Server DMV Replication Monitoring Part 2
  7. SQL Server DMV Replication Monitoring Part 3
  8. SQL Server DMV Replication Monitoring Part 4
  9. الأكواد الديناميكية لمراقبة ومتابعة حلول تزامن البيانات 1/ 3
  10. الأكواد الديناميكية لمراقبة ومتابعة حلول تزامن البيانات 2/ 3
  11. الأكواد الديناميكية لمراقبة ومتابعة حلول تزامن البيانات 3/ 3

Follow me because i will do one online session in replication and i will enhance all this posts by adding lot of other information in replication .

To check all my posts you can direct to my personal website or you can download this Excel sheet My Technical POSTS

View all my tips , LinkedIn Website Slideshare ,Youtube Channel.