• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by Jared K. · Apr 10, 2015 at 08:04 AM · production

Can I create a dashboard for Database summaries?

Currently we only have a license for dynatrace 6.1.

I have a request from a database administrator to see if we could possibly assist him with a dashboard to tell database size on a sql server. I don't see an explicit plugin or sensor that would do this for us.

He was also working on a job that he was going to run through SSIS that queried all of their servers and wrote the database size values to a table. Is it possible to track SSIS executions?

If the above is possible I know we can see database inserts that it is making in the sql query. I also know I can create a dashboard via filters to only show the given inserts. Can we break out columns and create measurements/alerts based on the values?

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

1 Reply

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by David M. · Apr 10, 2015 at 08:57 AM

Hi Jared, 

I'm not sure if you saw this plugin DB Query Monitor Plugin but you may be able to leverage it by writing a query to pull back the DB size and then capture that content. 

Someone else would have to answer your question about tracking SSIS executions.

Thanks, 
David 

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Jared K. · Apr 11, 2015 at 12:41 AM 0
Share

I had not, that I think will work perfectly for my needs and will negate the requirement of tracking SSIS since all I want is the table information anyways. Thanks a lot for this.

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Related Questions

Non entry web requests

Only monitor certain MQ Instances?

Trying to change default performance baseline

Security bbest practices when deploying DT with UEM

frontendServer memory configuration (increase size more than Medium Sizing)

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A