RSS

Monthly Archives: January 2015

High Availability Solution Database Mirroring in SQL Server 2008 R2

 Hi guys today i will share not explain the most important point in SQL Server  Mirroring Solution i will not explain because i already explained it before in 8 posts to download the Technical Document

High Availability Solution Database mirroring or you can Check it onlinehttp://www.slideshare.net/MostafaElmasry3/high-availability-solution-database-mirroring

Agenda and overview :

  1. Introduction about Database Mirroring Concept
  2. Note
  3. Database mirroring operation mode
  4. Database Mirroring Requirement
  5. Advantage of Database Mirroring
  6. Disadvantage of Database Mirroring
  7. Database Mirroring Enhancement in SQL Server 2008
  8. Database Mirroring Installation Step by Step
  9. High Availability Mode [Automatic Failover]
  10. High Availability Mode [Manual Failover]
  11. High Safety Mode Without witness server [Manual Failover]
  12. Stander listener port in database mirroring
  13. Check SQL server mirroring availability
  14. Add or replace witness server to an existing mirroring database
  15. How to monitor Database Mirroring
  16. Mirroring in workshop not in DC (Domain Controller)

Reference : 

Mirroring in SQL Server (8/8)
Mirroring in SQL Server (7/8)
Mirroring in SQL Server (6/8)
Mirroring in SQL Server (5/8)
Mirroring in SQL Server (4/8)
Mirroring in SQL Server (3/8)
Mirroring in SQL Server (2/8)
Mirroring in SQL Server (1/8)

Follow the author:

View all my tips , LinkedIn Website Slideshare 

 
2 Comments

Posted by on January 31, 2015 in General topics

 

Index and Execution Plan in SQL Server 2012,2014

Hi guys more DBA don’t know more information about the index and Execution plan and how you can understand Execution plan to build the best index model to enhance the performance for the Query from the Execution time and from the IO and CPU so for this reason i collected the most important posts on our community related to the index and Execution plan on one post to be as repository.

Follow the author:

View all my tips , LinkedIn Website Slideshare 

 
1 Comment

Posted by on January 26, 2015 in General topics

 

Where is index location on Database?

Where is index location on Database?

Where is index location on Database? 

Hi guys today I will show smoothing is easy but more important to know about it {Where is the index live} by the below DMV we can return all the index with table name and with File group hosted on it , another thing you can use this DMV to know the heap tables , Clustered index , non-Clustered index

Index Location:

WITH C AS
(

SELECT ps.data_space_id
, f.name
, d.physical_name
FROM sys.filegroups f
JOIN sys.database_files d ON d.data_space_id = f.data_space_id
JOIN sys.destination_data_spaces dds ON dds.data_space_id = f.data_space_id
JOIN sys.partition_schemes ps ON ps.data_space_id = dds.partition_scheme_id

UNION

SELECT f.data_space_id
, f.name
, d.physical_name
FROM sys.filegroups f
JOIN sys.database_files d ON d.data_space_id = f.data_space_id
)
–SELECT * FROM c
SELECT [ObjectName] = OBJECT_NAME(i.[object_id])
, [IndexID] = i.[index_id]
, [IndexName] = i.[name]
, [IndexType] = i.[type_desc]
, [Partitioned] = CASE WHEN ps.data_space_id IS NULL THEN ‘No’
ELSE ‘Yes’
END
, [StorageName] = ISNULL(ps.name, f.name)
, [FileGroupPaths] = CAST(( SELECT name AS “FileGroup”
, physical_name AS “DatabaseFile”
FROM C

WHERE i.data_space_id = c.data_space_id
FOR
XML PATH(”)
) AS XML)
FROM [sys].[indexes] i
LEFT JOIN sys.partition_schemes ps ON ps.data_space_id = i.data_space_id
LEFT JOIN sys.filegroups f ON f.data_space_id = i.data_space_id
WHERE OBJECTPROPERTY(i.[object_id], ‘IsUserTable’) = 1
ORDER BY [ObjectName], [IndexName]

index

Follow me because next post I will explain everything about the index and How you can build you index model How you can Enhance your expensive query by index more Secrets in the index …ETC

 

 
Leave a comment

Posted by on January 22, 2015 in Administration

 

Tags: , , ,

In love of SQL Server 2014

Because our community is believing in SQL Server 2014 performance dreams based so that we are all trying nowadays to unveiled all of its new performance features and make spotlight on the most important ones for both DB developer and administrator through the below logs , I am urging everybody who even didn’t breath air for SQL Serer to read them and of course he will enjoy extremely working with SQL Server 2014 :

In English:

 

Also In Arabic :

 
Leave a comment

Posted by on January 18, 2015 in General topics

 

Tags: