RSS

Monthly Archives: April 2015

My First Arabic post on Microsoft MSDN in SQL Server 2014

Hello Guys this my First Arabic post on Microsoft MSDN in SQL Server 2014 in very important subject Durable vs. Non-durable tables: In-Memory OLTP 

All My Arabic Posts :

تكنولوجيا الجداول الدائمه والغير دائمه Microsoft SQL Server 2014

الصلاحيات الجديده فى محرك قواعد بيانات مايكروسوفت 2014

أهم بعض الأكواد الديناميكيه المستخدمه فى محرك قواعد بيانات مايكروسوفت 2014

الأكواد الديناميكية لمراقبة ومتابعة حلول تزامن البيانات 1/ 3

الأكواد الديناميكية لمراقبة ومتابعة حلول تزامن البيانات 2/ 3

الأكواد الديناميكية لمراقبة ومتابعة حلول تزامن البيانات 3/ 3

أكواد الفحص الدورى والتشخيص الديناميكيه لمحرك قواعد بيانات مايكروسوفت 2014 الجزء 1

تكنولوجيا الجداول الدائمه والغير دائمه Microsoft SQL Server 2014

Follow ME

View all my tips , LinkedIn Website Slideshare ,Youtube Channel

 
Leave a comment

Posted by on April 30, 2015 in Arabic Posts, MSDN

 

Tags: , , , , , , ,

SQL Server 2014 Health check DMV queries Day 5

Hi guys in the Previous post i explained How we can get the SQL Server NUME Information and How to get Hardware Information  put today in DAY 5 i will show new DMV in our track Instance Level configuration .

DMV#11 Getting the Server Model Number

by the below DMV we can know the capacities of database System Manufacturer

EXEC xp_readerrorlog 0, 1, "Manufacturer";

DMV#11

DMV12# Getting the Processor Description

You should know the type of the Processor  of your Windows Server that the SQL Server instance Hosted on it based on that check the DMV

Read the rest of this entry »

 
1 Comment

Posted by on April 28, 2015 in SQL Server 2014

 

Tags: , ,

SQL Server 2014 Health check DMV queries Day 4

Hi guys in the Previous post i explained How we can get the Global Trace Flag Information ,  Getting Information About Windows and How to return SQL Server Services Information  put today in DAY 4 i will show new DMV in our track Instance Level configuration 

DMV#9 SQL Server NUMA Info

by the below DMV we can return more helpful information related to SQL Server NUMA info and it will return also the Node status , and load balance .


SELECT node_id, node_state_desc, memory_node_id, processor_group, online_scheduler_count,
 active_worker_count, avg_load_balance, resource_monitor_state
FROM sys.dm_os_nodes WITH (NOLOCK)
WHERE node_state_desc <> N'ONLINE DAC' OPTION (RECOMPILE);


DMV#9

DMV#10 Getting Hardware Information

very fantastic DMV and very helpful by the below T-SQL we can return lot of information about Hardware like Logical CPU count , Physical Memory , Physical CPU count , SQL Start time …ETC

virtual_machine_type_desc of HYPERVISOR does not automatically mean you are running SQL Server inside of a VM
It merely indicates that you have a hypervisor running on your host

SELECT cpu_count AS [Logical CPU Count], scheduler_count, hyperthread_ratio AS [Hyperthread Ratio],
cpu_count/hyperthread_ratio AS [Physical CPU Count],
physical_memory_kb/1024 AS [Physical Memory (MB)], committed_kb/1024 AS [Committed Memory (MB)],
committed_target_kb/1024 AS [Committed Target Memory (MB)],
max_workers_count AS [Max Workers Count], affinity_type_desc AS [Affinity Type],
sqlserver_start_time AS [SQL Server Start Time], virtual_machine_type_desc AS [Virtual Machine Type]
FROM sys.dm_os_sys_info WITH (NOLOCK) OPTION (RECOMPILE);

DMV#10

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.

Follow up us on

Facebook Page Link

 
1 Comment

Posted by on April 26, 2015 in SQL Server 2014

 

Tags: , , ,

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

 
1 Comment

Posted by on April 25, 2015 in SQL Server 2014

 

Tags: , ,

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.

 
1 Comment

Posted by on April 23, 2015 in SQL Server 2014

 

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

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.

 
Leave a comment

Posted by on April 22, 2015 in SQL Server 2014

 

Tags: , ,

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.

 
4 Comments

Posted by on April 16, 2015 in SQL Server 2014

 

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,