Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with dmv
Search options answers only
not deleted
user 44801
DMV in SQL Server is a catch-all term for Database Management Views [& Functions]. Technically they are all now DMOs (Database Management Objects) however the term DMV is still widely understood and accepted by most.
10
votes
Accepted
How to find out the account(s) under which the sql server is running?
In SQL Server 2005 and SQL Server 2008 there was no documented way. So undocumented command xp_regread was used to get the result
DECLARE @sn NVARCHAR(128);
EXEC master.dbo.xp_regread
'HKEY_LOCA …
- 7,177
1
vote
Which dmv can help identify the cost of index maintenance for exisitng and missing indexes?
The answer to this question could be very broad as it depends upon the workload of Sql server where you want to do index tuning. A good starting point would be SP_BlitzIndex ( link https://github.com …
- 7,177
3
votes
No rows in sys.dm_exec_procedure_stats for a particluar stored procedure
By using this DMV, you can returns metrics for stored procedures, but
it does not directly identify the stored procedure by name. … Instead,
the DMV only identifies the object_id, and a database_id for each
stored procedure: Therefore to identify the actual stored procedure
name, that the performance figures belong to, you should …
- 7,177
0
votes
Discover available HD storage from inside SQL Server
I use below query for my servers on SQL 2008R2 and SQL server 2005:
It involves enabling and configuring Enabling Ole Automation Procedures, within the script and later uses xp_fixeddrives to gather …
- 7,177
3
votes
Finding the query causing the missing index DMVs
finding-what-queries-in-the-plan-cache-use-a-specific-index/
and refer to link as well for more explanation on the same
http://blogs.lessthandot.com/index.php/datamgmt/dbadmin/sql-server-dba-tip-missing-index-dmv …
- 7,177
4
votes
how to find the T-SQL of a sleeping session that is blocking some other process?
You can use Adam Machanic's SP_WHOISACTIVE to get the details tracked.
One of the great things about sp_whoisactive is that it’s very quick to generate a table to collect the data you need, then run …
- 7,177