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 41723
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.
7
votes
Accepted
What are the practical impacts of the sys.dm_exec_query_stats warning in the documentation?
The intent was to tell the user that running a query against the DMV will produce output only for items that had completed and not for items in-flight. …
- 35.5k
9
votes
Accepted
Do values in `sys.dm_os_wait_stats` reset to 0 or stop accumulating when they hit the max va...
According to Docs:
In SQL Server the wait-time counters are bigint values and therefore
are not as prone to counter rollover as the equivalent counters in
earlier versions of SQL Server.
I'v …
- 35.5k
1
vote
Troubleshooting Resource Governor / Classification Function
Make sure your group name returned matches (identically) to your actual workload group name. Some times, I've found, it's helpful to reconfigure even if it doesn't say it needs to be done.
use master …
- 35.5k
3
votes
SQL 2019 CU13 breaks Cluster_nodename
This is an artifact of fixing some items with that DMV. It should be fixed in a future version. I'll update the answer with the version, when available. …
- 35.5k
4
votes
Accepted
Why is sqlserver_start_time not equal to sqlserver_start_time_ms_ticks - ms_ticks in sys.dm_...
Note that the highlighted values seem to match the DMV fairly well. … Windows Process Creation Time: 11/22/2022 11:46:23 AM
sql_server_start_time (DMV): 2022-11-22 11:48:08.550 AM
sql_Server_start_time_ticks (DMV, Calculated): 2022-11-22 11:47:34.240 AM
Thus, it seems ticks …
- 35.5k
6
votes
Accepted
Inconsistent result for NUMA node memory usage in SQL Server
for memory_node_id = 0 it shows more memory than physically available on the NUMA node. How can that be?
You're looking at the memory from the clerk perspective and assuming all of the memory for th …
- 35.5k
2
votes
Accepted
New DMVs related to Availability Groups in SQL Server 2019 CU9
It's really around as cached data so that the DMV can be hit often without incurring certain performance hits (think orchestration operations and polling). …
- 35.5k
4
votes
What is the difference between latency calculation using sys.dm_os_buffer_descriptors.read_m...
Now you query this DMV and it shows 0 for this BUF and average it, which brings down the overall average. …
- 35.5k
12
votes
Accepted
What is a "hashed transaction" in SQL Server Replication terminology?
In reality, this DMV (Dynamic Management View) won't be very helpful for a DBA or Developer and is geared to SQL server Product Support and Product Group. You can ignore this DMV. … Hash tables work well when there are a small number of items that fit into a bucket and this is an example of a DMV that support might use to check certain internal structures without the need of obtaining …
- 35.5k
2
votes
Accepted
Who was using a spid 2 hours earlier in SQL Server?
There is nothing that is logged or kept by default, you'd need to setup a trace/audit/etc. to get the information you desire.
- 35.5k
2
votes
Accepted
How to see the errors on AlwaysOn using T-SQL?
Those error messages, much as @Nic pointed out, are not really error messages in the log or in a DMV but are surfaced up through policy based management which runs as part of the AlwaysOn Dashboard. …
- 35.5k
3
votes
Accepted
what sql server is holding in the used memory?
[...] is there a way to find out what sql server is holding in there memory?
Yes and no, depending on what you mean by "holding in there memory" (sic).
If you mean what's using memory in the broad s …
- 35.5k
2
votes
database involved in availability group - showing state as online but it is synchronizing an...
how can I find the list of databases I actually can connect to?
Msg 976, Level 14, State 1
the database is synchronizing and it is showing as ONLINE
You'll want to see if the replica, in a secon …
- 35.5k