Just another module from my kernel…
First of all, whenever issues arise from patching your SQL Server production environment, please keep calm 🙂 In a scenario, that you successfully patched SQL Server (Service Pack/ CU) but the SQL Server Resource Group can’t be brought online, I recommend to start your PowerShell console and generate your Cluster Log (simply by Get-ClusterLog), this will
Hello world 🙂 To sum up, i was working with one of my customers regarding the UI (User Interface) freezing while restoring (Symantec NetBackup) a database into SQL Server 2012, leading to a unresponsive behavior from the server. Scenario (VMware guest – WS2012R2): Started with gathering performance counters to jump into the analysis and even though
If you are interested on a solution that provides elastic scale, High Availability and Disaster Recovery between different locations with a “pay as you go approach”, I suggest you to invest 2 minutes of your time to take a look of this session!
Kalen Delaney with Paulo Condeça on SQL PORT Meeting. More information about Kalen Delaney @ AboutKalenDelaney .
For who don’t know, it is know possible to remove Lock Escalation, and this is something that be “granularly” done to a table on SQL SERVER 2008 or Higher without the need to use Trace Flags. Sample sintax ALTER TABLE table_name_goes_gere SET (LOCK_ESCALATION=DISABLE) . — PT — Para quem não sabe, já é possível remover
To sum up, I had to solve a situation in a client that wasn’t able to run a couple of SSIS package with SQLSERVER AGENT but they were running ok in BIDS. Since SQL SERVER was running on a x64 environment, and the SSIS package was connecting to a excel files ( JET 4 OleDB
When you have a negative spid ( ex: -2) in SQL SERVER, it is related with Microsoft Distributed Transaction Coordinator (MSDTC). You can do it from 2 different ways: Outside SQL SERVER, in component services > DTC > Transactions > rollback the transaction. OR select distinct req_transactionUOW from syslockinfo , ignore the 000000’s kill ‘GUID’ . ( ghost/orphaned transaction
I’m writing this article to help everyone who whats “more juice” from a MS SQL SERVER INFRASTRUCTURE . Instead of writing lots of articles i will update this post every week. I will mix lots of concepts in this post, ranging from Physical Infrastructure/ Operating System/ SQL SERVER PARAMETERS / T-SQL . I will write a
Linux command to find files / directories . find . -name “WhatYouWant” -print
SSMS (SQL SERVER MANAGEMENT STUDIO) slow startup and how to optimize SSMS startup time : To sump up, everytime you open SSMS it will check some certs, so, do the following if you want faster load times : Open IE > TOOLS > OPTIONS > ADVANCED > UNCHECK PUBLISHER CERTIFICATE REVOCATION .
Paulo's SQL Server Weblog and other bytes 