It’s often important to understand what is using your tempdb. For the size: Break out user objects from the tempdb: View temporary tables created in tempdb:
Continue readingHDFS Under Replicated Blocks
This is an HDFS service-level health check that checks that the number of under-replicated blocks does not rise above some percentage of the cluster’s total […]
Continue readingHow to join and view data from SQL and HDFS through Drill
Configure Drill to query SQL Server Microsoft SQL Server can be reached by a jdbc driver they publish. The 4.0 version is compatible with jdk 7, […]
Continue readingManage Traces in SQL Server
Quick notes on managing traces in SQL Server: View all running traces: SELECT * FROM sys.traces Disable and delete the trace with the @status option […]
Continue readingDelete a Kafka Topic
Typical delete command: kafka-topics –zookeeper zk_host:port/chroot –delete –topic my_topic_name The topic will be “marked for deletion” and should be removed soon. What happens is an /admin/delete_topics/<topic> node […]
Continue readingBash: Output Text in Color
Output in red: echo “$(tput setaf 1)Red Text$(tput sgr0)”
Continue readingPowerShell script to convert string to encrypted password and back again
I’ve found it useful to store an encrypted password in a file on disk. However, this is not generally a good idea but at least […]
Continue readingFind and Delete Running SQL Trace
Yesterday we had a long running trace take up too much space on disk. To find the running trace, look for the location of the […]
Continue readingPerformance Tuning in SQL Server
I wanted to capture a few notes on performance tuning in SQL Server. CPU and memory: select * from sys.dm_os_performance_counters where counter_name in (‘Batch Requests/sec’, […]
Continue readingMonitoring SQL AlwaysOn
SQL AlwaysOn offers DMVs that make monitoring simple. use master go select * from sys.dm_hadr_cluster_members select * from sys.dm_hadr_cluster select * from sys.dm_hadr_cluster_networks go SELECT […]
Continue reading