Groups > comp.databases.ms-sqlserver > #1616

Re: can I get some info on DMV ?

X-Received	by 10.182.104.200 with SMTP id gg8mr1140453obb.45.1384125839391; Sun, 10 Nov 2013 15:23:59 -0800 (PST)
X-Received	by 10.49.48.68 with SMTP id j4mr502qen.13.1384125839306; Sun, 10 Nov 2013 15:23:59 -0800 (PST)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!o2no28541317qas.0!news-out.google.com!9ni19861qaf.0!nntp.google.com!i2no19569783qav.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Sun, 10 Nov 2013 15:23:59 -0800 (PST)
In-Reply-To	<46529729-0f23-4dff-a4bb-54e6b900c962@googlegroups.com>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=76.185.132.163; posting-account=EZnBRwoAAACoVatc_dcLXiTV2692t6O1
NNTP-Posting-Host	76.185.132.163
References	<46529729-0f23-4dff-a4bb-54e6b900c962@googlegroups.com>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<82a151ab-0754-43e9-8bd6-378be4e19415@googlegroups.com> (permalink)
Subject	Re: can I get some info on DMV ?
From	kedar@techsql.net
Injection-Date	Sun, 10 Nov 2013 23:23:59 +0000
Content-Type	text/plain; charset=ISO-8859-1
Xref	csiph.com comp.databases.ms-sqlserver:1616

Show key headers only | View raw

On Sunday, November 10, 2013 5:22:34 PM UTC-6, dbaon...@gmail.com wrote:
> can I get some info on DMV ?

DMVs expose server state in queryable format.

We are referring here in memory state.
You can refer below article for the same.
http://www.techsql.com/list-dynamic-management-views-dmv-by.htm

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

can I get some info on DMV ? dbaonline99@gmail.com - 2013-11-10 15:22 -0800
  Re: can I get some info on DMV ? kedar@techsql.net - 2013-11-10 15:23 -0800

csiph-web