Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Highly Rated Users

Forum
No Posts Rated

Top 50
Given
Received

Links

Wiki
Blog

Forum Statistics

Users
Members:
1875
Members Online:
2
Guests Online:
21

Total Post History
Posts:
81447
Topics:
18714

7-Day Post History
New Posts:
0
New Topics:
0
Active Topics:
0

Our newest member
konam534As

Other

FAQ
All times are UTC [ DST ]

Google Ads

Gathering Statistics Specific To Front End Servers

Please wait...

Gathering Statistics Specific To Front End Servers

Postby AlexCuse on Fri Jul 10, 2015 7:23 pm

Our system currently relies heavily on a table that is rebuilt frequently. Rebuilding this table is the cause of probably 2/3 of the weird timeout issues that users end up seeing. We are trying to replace with a view, but can't replace with an indexed view because a union is involved. This makes for a slightly more interesting query plan, though it may be offset by not rebuilding that table umpteen times a day.

What we want to do is create a new branch off of production containing the code changes needed to use the view and bypass executing the stored proc (fairly minimal) and monitor for a week or two. While this will likely tell us if anything is horribly wrong, it doesn't tell us a whole lot.

Is there a good way without running a server side trace and chewing through the output to get a good picture of the database load generated by each server in a setup like this?
Say what you like about the tenets of National Socialism Dude, at least it's an ethos
User avatar
AlexCuse
LTD Admin
LTD Admin
LTD Gold - Rating: 1031LTD Gold - Rating: 1031LTD Gold - Rating: 1031LTD Gold - Rating: 1031LTD Gold - Rating: 1031
LTD Gold - Rating: 1031LTD Gold - Rating: 1031LTD Gold - Rating: 1031LTD Gold - Rating: 1031LTD Gold - Rating: 1031
LTD Gold - Rating: 1031
 
Posts: 5523
Joined: Tue Oct 09, 2007 5:26 pm
Location: Pennsylvania, US
Unrated