RE: Custom performance report from SBSMONITORING database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hi Joe,

Thanks for posting in our newsgroup.

From your description, I know that you want to create a SQL query to know
the 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
<
<
<
<

.



Relevant Pages

  • RE: SBS 2003 Fax Problems (Excel 2007 + Vista)
    ... Click Services tab and select Hide All Microsoft Services and Disable ... Mostly the problem is related to the configuration of your Excel file. ... please don't hesitate to let me know. ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem adding CALs
    ... please don't hesitate to let me know. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... <Thread-Topic: Problem adding CALs ...
    (microsoft.public.windows.server.sbs)
  • Re: Cisco Client Cannot Connect Outbound
    ... Please do not hesitate to let me know if you have any questions or concerns ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... newsgroups so that they can be resolved in an efficient and timely manner. ...
    (microsoft.public.windows.server.sbs)
  • RE: Problem With Sending faxes with Cover Pages
    ... Click Services tab and select Hide All Microsoft Services and Disable ... Click OK and choose Restart. ... please don't hesitate to let me know. ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem with connect computer wizard
    ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... Please double-check the default application pool in IIS. ...
    (microsoft.public.windows.server.sbs)