Problem: Many a times you need to defragment indexes on SQL server. Following query is quite handy for doing this[…]
Read moreMonth: December 2015
SQL Server -Find Blocking
Problem: Many a times DBA/Developer needs to identify the blocking in SQL server. Following queries will help you out. Solution:[…]
Read moreSSAS-Find blocking onSSAS Tabular server
Problem: How to find blocking on SSAS Tabular server? Solution: Option1: select *from $system.discover_locks where lock_status=0 Option2: SELECT [SESSION_COMMAND_COUNT], [SESSION_CONNECTION_ID], [SESSION_CPU_TIME_MS],[…]
Read moreHadoop: Check version
Problem: How to check the version of the Hadoop installed in your environment? Solution: ps -ef |grep Hadoop
Read moreSpark: Check version of Spark on CDH
Problem: How to check the version of the spark installed in your environment? Solution: Search for “spark-shell” in file system. in[…]
Read more
