-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Geek

Dharmendra is a SQL Server/Microsoft Data Platform professional with over eight years of experience. He enjoys helping others in the SQL Server community and does this by contributing on blogs, speaking at several SQL events. His passion and focus is to explore and share more and more on SQL Server.

Archives: June 2017

SQL SERVER DATABASE FILES WISE I/O LATENCY PART#2

Since the DMF sys.dm_io_virtual_file_stats shows cumulative I/O statistics value for the database files, you can’t just use the DMF to shoot a conclusion that the database files are experiencing high latency issue. The reason is the overall aggregation will mask spikes of poor performance.

It is recommended to capture the… Read more

0 comments, 231 reads

Posted in SQL Geek on 29 June 2017

SQL Server Database Files Wise I/O Latency Details PART#1

One of the real-world I/O troubleshooting problems is – If you have your databases spread across multiple LUNs and you want to find out which database files are experiencing high latency issues and driving the most I/Os to storage subsystem using performance counter (Avg. Disk sec/Read & Avg. Disk sec/Write).… Read more

4 comments, 1,518 reads

Posted in SQL Geek on 26 June 2017

How the Initial VLF sequence number gets decided of the default transaction log file

In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed the undocumented command DBCC LOGINFO, one of the common questions which I got – ‘How the Initial VLF sequence number gets decided of the default transaction log file’?… Read more

0 comments, 820 reads

Posted in SQL Geek on 20 June 2017

Install SQL Server Agent on Ubuntu (Linux)

With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to schedule any task using a SQL Server Agent Job on Linux machine. In this post, I will explain how to install the SQL Server Agent package on the Ubuntu system. Read more

0 comments, 308 reads

Posted in SQL Geek on 16 June 2017

SQL SERVER ON LINUX INSTALLATION – PART4 – Install SQL Server Tools on Ubuntu – Updated!

Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it individually. In my previous posts of this series, I discussed how to create a virtual machine using Windows Hyper-V, how to install Ubuntu Server on the created virtual machine and how to… Read more

0 comments, 512 reads

Posted in SQL Geek on 13 June 2017

SQL Server 2017 – DMF – sys.dm_db_log_info

The release of Microsoft SQL Server 2017 brought a lot of very interesting new features. One of them is the addition of DMF sys.dm_db_log_info. It allows having a look at the structure of the transaction log without using the undocumented DBCC LOGINFO command. 

DMF – sys.dm_db_log_info

It returns VLF information… Read more

0 comments, 218 reads

Posted in SQL Geek on 12 June 2017

Top Function – Performance Gain

Recently, I presented at Singapore SQL Pass Chapter on the topic T-SQL Fun, and the most of the attendees were a developer. During the session, I discussed TOP function, and I throw a question to the audience – “Not using Top function especially when you can use it – Can… Read more

0 comments, 184 reads

Posted in SQL Geek on 5 June 2017