Skip to content

SQL Canada (SQLCAN)

Data – Analytics – AI – Random Thoughts

  • Home
  • About
  • DBA Queries
  • Acclaim Badges

Category: Windows 2008 R2 Clustering

Missing registery settings in cluster nodes for SQL Server

October 27, 2014 Mohit

I run into this occasionally, I think in last 3-4 years being SQL Server PFE, I have seen this issue total of 4 times.  So

Continue reading

Rate this:

Slow disk write performance when you use a back-end SAN on a computer that is running Windows Server 2008 R2

November 14, 2012 Mohit

Interesting fix was released today, your WRITE performance might be poor due to incorrect priority in DPC in Windows 2008 R2. If you have write

Continue reading

Rate this:

Setting up iSCSI Target and Initiator

August 13, 2012 Mohit

I am sure everyone has realized, when it comes to configure Servers I am the last person that should get near them.  I am good

Continue reading

Rate this:

Contact Me

mohitkgupta@msn.com
Contact me if you need assistance with PTO, HADR, Automation, etc. :)
MCC 2012

Categories

  • Administration (30)
  • Announcement (17)
  • Azure (1)
    • Azure Storage (1)
  • Best Practices (3)
  • Database Mirroring (5)
  • Disaster Recovery (5)
  • Documentation (1)
  • Dynamic Management Views/Functions (11)
  • Full Text Search (2)
  • High Availability and Disaster Recovery (18)
    • AlwaysOn Availability Groups (3)
    • Cluster Errors (1)
    • SQL Failover Cluster (2)
    • Windows 2003 Clustering (3)
    • Windows 2008 Clustering (9)
    • Windows 2008 R2 Clustering (3)
  • Interesting Reads (11)
  • Maintenance Plans (2)
  • Operating System Errors (2)
  • Performance Tuning (21)
  • Published Article (2)
  • Reporting (7)
    • Power BI (2)
    • Power BI Desktop (2)
    • Report Builder (1)
    • SSRS 2000 (1)
    • SSRS 2008 (1)
  • Security (10)
  • Smart Index Management (3)
  • SQL 2000 (5)
  • SQL 2005 (29)
  • SQL 2008 (18)
  • SQL 2008 R2 (11)
  • SQL 2012 (16)
  • SQL 2014 (11)
  • SQL 2016 (15)
  • SQL Bootstrap Errors (1)
  • SQL Embedded Edition (1)
  • SQL Errors (15)
  • SQL Internals (2)
  • SQL Protocols (1)
  • SQL Replication Errors (1)
  • SQL Server Tools (1)
    • SQL Server Configuration Manager (1)
  • T-SQL Reference (4)
  • Tinkering (1)
  • Tools (14)
  • Troubleshooting (30)
  • Windows 2008 (1)
  • Windows 2008 R2 (2)

Tags

ApexSQL Tools Authentication Central Management Server CMS Computed Columns CTE CTP Database Corruption DBA Queries DBCC CHECKDB Distributed Transactions DMF - sys.dm_exec_query_plan DMF - sys.dm_exec_sql_text DMF - sys.dm_io_virtual_file_stats DMV - sys.dm_exec_query_stats DMV - sys.dm_exec_requests DMV - sys.dm_os_waiting_tasks File Header Corruption fn_dblog Hekaton in-doubt xact resolution In-Memory OLTP Index Management Jan 2019 Update KB Articles Kerberos KILL Lazy Writer Maintenance Plans Microsoft Forever Modeling mofcomp M Query Language Multi-Server Management Named Pipes Negative Session IDs NOLOCK Hint Non-Technical NUMA Configuration OBJECT_NAME Operating System Error 5 PAL perfmon Performance Counters Power Query Language PowerShell Presentation Processor Imbalance References Security Service Principal Names (SETSPN) Slicer Pane Smart Guides SQL Error 3117 SQL Error 5172 SQL Error 6101 SQL Error 18456 SQLPASS SQL Patches & Hotfixes SQL Server Disaster Recovery SSIS SSMS SSMS 2008 SSPI Error Suspect Database Syntax Highlight sys.database_mirroring_endpoints sys.dm_tran_active_transactions sys.dm_tran_locks sys.indexes sys.sysprocesses sys.tables sys.tcp_endpoints Undocumented Functions Wait Types

Archives

Administration Links

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

Blog Stats

  • 135,592 hits
Website Powered by WordPress.com.
  • Follow Following
    • SQL Canada (SQLCAN)
    • Join 162 other followers
    • Already have a WordPress.com account? Log in now.
    • SQL Canada (SQLCAN)
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar