Thursday, September 19, 2013

[SQL 2012] Disaster Recovery - SQL vs VM Disk Replication

[SQL 2012] Disaster Recovery - SQL vs VM Disk Replication

Disaster Recovery - SQL vs VM Disk Replication

Posted: 19 Sep 2013 02:22 AM PDT

We are evaluating approaches to DR. For SQL Server we have the usual log shipping, replication, and various 'AlwaysOn' methods. The other approach is to use one of the Hypervisor or SAN based disk level replication technologies.Certainly, one advantage of the SQL approaches is the the system at the remote DR site is 'warm' or even 'hot'.But I have not been able to find discussions on the relative efficiency of the two approaches. I would imagine that any Hypervisor or SAN based replication needs to replicate ALL the disk writes. That includes the MDF as well as the LDF writes etc., AND any Windows NTFS writes such as the system journal and file attribute structures if the file grows or shrinks. Whereas the SQL methods are really only replicating the resulting DB change, and letting the remote system apply the change.I would think that the SQL replication could therefore use significantly less network bandwidth between the primary and DR sites.Does anyone have any experience or opinions here???Thanks,Dave

SSRS 3.0 average

Posted: 19 Sep 2013 12:12 AM PDT

Hi all, I am trying to do an average of a calculated collumn in SSRS (matrix table), the column in question is the result of an expression =sum(Fields!Current_AR.Value) / sum(Fields!Total_AR.Value), now i want to do the average of this collumn but i cant seem to do it..Anyone got a suggestion?Best regards,Daniel

Question on certificate and asymmetric logins

Posted: 18 Sep 2013 01:42 PM PDT

Hello all,I have a classic question (probably for most of you), as I am new to dba. Why do we use certificate or asymmetric types of login?As far as I know, Windows and SQL server authenticated logins will do fine jobs. In what scenario does one use certificate or asymmetric logins? I can only see one benefit that you can set specific expiry date for certificate logins, but other than that i can not see anything significant. So based on that, why do we need them?Please your advise, correct me if I am wrong. Thanks.

Extended Events

Posted: 18 Sep 2013 04:02 PM PDT

Dear AllI am trying to find out why some procedures are getting recomiled. For this when i run following select,SELECT deqs.last_execution_time AS [Time], dest.text AS [Query],dest.dbidFROM sys.dm_exec_query_stats AS deqsCROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS destORDER BY deqs.last_execution_time DESCit gives out put as many lines of "Create procedure...."To find out the reason for "create procedure ...", I tried with extended event. I am capturing SQLStatementREcompile event. But when start the session and check the live data, it does not show same numbers of lines as shown by above select.Am i missing some thing?Regards

Accidental DBA - Where to Start? (General Question)

Posted: 18 Sep 2013 03:23 AM PDT

Hello,I will be taking over the role of a SQL Server DBA for my company. Our SQL Servers have always been maintained by our Server Admins. I will be going to training in about a week. I would like any suggestions on what I should begin looking at when I come back from training. I am familair with SQL Server Versions 2005, 2008, and 2008 R2 from a developers viewpoint. The DBA role will be new to me. What would be some of the first issues I should address as I take over the responsibility of these databases?Thanks!
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog