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 readingCategory: SQL
SQL
How 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 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 readingSQL Query for Recently Changed Objects
These may be useful to determine when objects have been changed. We might infer from this info when was the last formal deployment of a […]
Continue readingFix an SQL Database Marked Suspect
If you have a database marked suspect, and do not have a backup to restore from, you can attempt to repair the database. This may […]
Continue readingPurge Backup History from SQL msdb Database
I just about ran out of space on my Data partition and discovered that the msdb database was over 114 GB! In particular, the backupfile […]
Continue readingQuery for the Size of All Databases in SQL
If you need to see the size of all databases on an SQL server, here is a helpful query, one I always seem to need […]
Continue reading