Month: December 2014

SQL Server or MySQL for our Business Needs?

Business Need: Currently we are in the cross-roads of growing from small-mid sized company to large scale K-12 online Test Delivery and reporting Solution provider. We primarily operate on K-12 Summative Market and its absolutely critical for us  to provide 100 % accuracy

SQL Server 2014 – Memory Optimized Tables

Our Team Need : We have about 5-500 GB Databases and very few tables ( ~ About 10 tables ) are high volume high concurrency tables. At peak volume, we may write few thousands per second per table. We are

XACT_ABORT Settings and Connection Timeout Nuances

We have .NET Application connecting to SQL Server database. I have noticed the timeout from the Application while calling the stored Procedure. We didn’t configure any specific timeout limit , so we were using default 30 Sec Timeout. Its pretty

SQL Handle to SQL Text

SQL Handle to SQL Text with Statement Start and Statement End:

Deadlocks : Count , Analysis and Event Notification

SQL Server : Number of Deadlocks since Last SQL Server Restart

Extended Events Query:

DEADLOCK Query from Extended Events:

Decipher waitresource= “KEY: 27:72057596131278848 (1413e0809b53)”

DBCC Usuage:

SQL Handle to SQL Text :

Object

SQL Server – Read Errorlog

Enable Audit log to capture successful and failed Logins — To Enable Failed and Successful Logins — Need to Restart the Server for this to effect

— Query for Successful Logins

— Login succeeded for user ‘xxxxxx’. Connection

Top