Tag Archives for " Microsoft SQL Server "

Feb 2016 Tip of the Month – New function in SQL 2016: sys.dm_exec_function_stats

By SQLRx Admin | Intermediate , Performance Tuning , SQL Server , Tip of the Month

SQL Server Performance Tuning:  New function in SQL 2016: sys.dm_exec_function_stats Returns performance statistics for cached functions. Returns information about scalar functions, including in-memory functions and CLR scalar functions but not about table valued functions. The view returns one row for each cached function plan, and the lifetime of the row is as long as the […]

Continue reading

SQL Server 2012/2014 Extended Events for Developers – Part 1

By Jeffry Schwartz | Expert , Performance Tuning , SQL Development , SQL Server

— By Jeffry Schwartz Microsoft introduced Extended Events, a.k.a. XEvents, in SQL Server 2008 to aid in the analysis of performance problems. Both the capabilities and syntax were changed significantly on SQL Server 2012, and new (and very important) features were added in SQL Server 2014. Therefore, the focus of this document will be on […]

Continue reading

Jan 2016 Tip of the Month: sys.dm_server_memory_dumps

By SQLRx Admin | Intermediate , SQL Server , Tip of the Month

January 2016 Tip of the Month:  Using sys.dm_server_memory_dumps to find SQL memory dumps. When SQL experiences a serious issue it will often dump the contents of its memory to disk. This is known as a memory dump and it does generate files that are usually located in the Logs folder. I often find that many […]

Continue reading

Repair Suspect Database – SQL Server

By Ginger Daniel | Expert , SQL Administration , SQL Server

– -by Ginger Keys Occasionally mistakes happen, things get deleted, or hardware fails. Your end users may be complaining that the application is not working or pulling up any data… or you may open SQL Management Studio and see that the database is simply unavailable. What happened!? I have encountered a situation where an inexperienced […]

Continue reading

SQL Server Audit Feature

By Ginger Daniel | Intermediate , SQL Administration , SQL Server

— By Ginger Keys Once upon a time there was an organization that depended on very accurate data entry rules.  For various reasons, some of the employees who were responsible for inputting and updating records were not very diligent about following rules to keep the data clean and uniform, reasoning that IT would go behind […]

Continue reading

Disk Metrics – Why PerfMon’s, SQL Server’s Filestats, and Disk Vendors’ Values Sometimes Appear to Disagree

By Jeffry Schwartz | Expert , Performance Tuning , SQL Server , Windows

— By Jeffry Schwartz Whenever multiple data sources are used, actual or perceived discrepancies can arise. Sometimes this is due to the location of the data collector, e.g., Windows, SQL Server, or the disk array. Other times, it is due to the collection rate and whether the information is a simple recording of continuously incremented […]

Continue reading

Stored procedure execution info with query plan

By Lori Brown | Expert , Performance Tuning , SQL Administration , SQL Server

Sometimes it is good to have some queries in your toolkit that give you information on how things are running that includes the actual execution plan. While looking at Glenn Berry’s diagnostic query scripts (http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-september-2015/), which are very good btw, I found queries that will list stored procedure statistics but none had the execution plan […]

Continue reading

How to connect using the Dedicated Administrator Connection

By SQLRx Admin | Intermediate , SQL Administration , SQL Server , Tip of the Month

The SQL dedicated administrator connection(DAC) has been around since SQL 2005 and is a diagnostic connection that is designed to allow an administrator to troubleshoot SQL Server when the instance is having problems.  Only members of the sysadmin role can connect using the DAC.  You can connect using the DAC both through SQLCMD (SQLCMD –A […]

Continue reading

Reset a lost or forgotten SA password

By Lori Brown | Beginner , SQL Administration , SQL Server

— By Lori Brown  @SQLSupahStah Any login that is a member of the sysadmin role can reset the SA password. But, what if you have a hostile takeover by an application or for some strange reason don’t have any other logins as members of the sysadmin role?   Don’t laugh!  I have actually run into both […]

Continue reading