RE: Custom performance report from SBSMONITORING database
- From: v-robeli@xxxxxxxxxxxxxxxxxxxx (Robert Li [MSFT])
- Date: Wed, 07 Feb 2007 06:31:12 GMT
Hi Joe,
Thanks for posting in our newsgroup.
From your description, I know that you want to create a SQL query to knowthe processor and memory usage growth in the past 6 months from
SBSMonititoring.mdb. If I am off-base, please don't hesitate to let me know.
I am sorry that we don't provide technical support in our newsgroup because
it's a SQL issue. Please open a new post in microsoft.public.sql newsgroup.
If you need further assistance, please don't hesitate to let me know.
Best regards,
Robert Li(MSFT)
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.
Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.
For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.
Any input or comments in this thread are highly appreciated.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
<From: "news.microsoft.com" <jm@xxxxxxxxxxxxxx>
<Subject: Custom performance report from SBSMONITORING database
<Date: Tue, 6 Feb 2007 16:11:53 -0800
<Lines: 17
<X-Priority: 3
<X-MSMail-Priority: Normal
<X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
<X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
<X-RFC2646: Format=Flowed; Original
<X-Antivirus: avast! (VPS 000711-0, 06/02/2007), Outbound message
<X-Antivirus-Status: Clean
<Message-ID: <O7OEQykSHHA.488@xxxxxxxxxxxxxxxxxxxx>
<Newsgroups: microsoft.public.windows.server.sbs
<NNTP-Posting-Host: 216.19.188.236.novuscom.net 216.19.188.236
<Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP06.phx.gbl
<Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:15382
<X-Tomcat-NG: microsoft.public.windows.server.sbs
<
<Hello,
<
<Does anyone know how to create a SQL query that will extract specific
<performance data from the SBS 2003 monitoring database (SBSMonitoring.mdf)?
<
<What I'm hoping to do is generate a custom report showing how the
processor
<and memory resource usage has grown for particular processes (i.e.
<store.exe) over a 6 month period. I'm not sure that the database keeps
<information going that far back, but its about 350MB so there must be
<something in there.
<
<Please let me know if you would like more information,
<Much appreciated,
<Joe Marriott
<
<
<
<
.
- References:
- Custom performance report from SBSMONITORING database
- From: news.microsoft.com
- Custom performance report from SBSMONITORING database
- Prev by Date: RE: OWA 2003 with ISA 2004
- Next by Date: RE: Router as VPN endpoint
- Previous by thread: Custom performance report from SBSMONITORING database
- Next by thread: slow client on SBS 2003R2 network
- Index(es):
Relevant Pages
|