|
|
Tip: Please be sure to add newsletter@sswug.org when configuring your email filters.
Making a Difference with SQL Server
Making a Difference
Many people wrote in asking about roles and responsibilities ("do I need to do analyst work to be an asset for the company??") and how this plays into the editorial from yesterday. Well, I don't think we should revisit the job title and responsibilities thing right now (we just completed a really good discussion about that), but I will say that that's not what I meant, not really.
This is a time to really kind of ignore the titles and responsibilities and help your company or companies get the most from their systems. Doesn't really matter if you're the analyst or admin, if you can leverage what you know about databases, if you can contribute anything more at all, now's the time to do so. Step up, teach people how to pull more from the information, look for new uses, new reports, updated information presentation. There is a lot that can be added when someone new that "thinks database" gets involved, no matter what their official title.
So, What WAS That Tool?
Last week I wrote about some performance issues we were chasing. The issues were revolving around a symptom of disk queues growing, system performance lagging in spurts, etc. We were having trouble getting real visibility into all of the possible causes, in a cohesive, single look kind of way. It was one thing to look at queries running, another to check counters, yet another to look for lock/blocking... you get the idea. Pulling it all together was challenging. All the while, we had pressure to get things back going correctly.
I had twittered (twitter.com/swynk) about some of the things we were seeing and what we were doing to investigate a bit. The folks over at SQL Sentry jumped on that and helped us out - they helped show off their new performance dashboard tools and at the same time shine some serious light on our server and the issues we were seeing. Literally as soon as we fired it up we could see what was happening. Not the cause, but the symptoms across the various impacted areas of the servers. That's step 1 - gather information.
Step 2, of course, is to solve the issue. Clicking on the graph where the performance hit kicked off, then selecting "Top SQL" shows exactly what's running. Now we're getting somewhere. From there, we could readily see that the full-text queries were running *every* time the issue occurred, and we could also correlate that execution time on the SQL with the disk graph... needless to say we quickly narrowed down the possibilities.
If you're curious, and may have missed it, we ended up moving the full text indexes to different drives. We also ended up messing with stats. Check out the editorials for more info.
The key here was that the SQL Sentry Performance Dashboard tool did an amazing job helping us dive in to correlated information points - sort of "show me a complete system picture at this point in time" - and it led to fact-based troubleshooting that solved our problems.
Get more information about their software here (there is a free trial - fire it up and point it at your servers to get a great feel for how things work).
This isn't an ad, not a review. It was just a truly critical piece in understanding what was going on - and many people wrote asking what we used.
Thanks to the SQL Sentry team for the assist - we appreciate the help!
Featured White Paper(s)
7 Ways to Improve Your Database Server's Performance by 60%-80%
Sql Power Tools White Paper reviews 7 steps you can take to improve your database server's performance. With production datab... (read more)
SQL Server Fragmentation Explained
As the data in Microsoft SQL Server tables changes, their indexes change. Over time, these indexes become fragmented. This fr... (read more)
See you online!
Stephen Wynkoop,
Founder
Microsoft SQL Server MVP
swynk@sswug.org
|
|
 |
SSWUG Ultimate Virtual Conference
vConferenceonline.com and SSWUG will present the largest online learning event covering Business Intelligence, SQL Server, Sharepoint and .NET Development November 5, 6 and 7. The event will run twelve simultaneous tracks featuring over 40 well-known industry experts. The conference offers broadcast quality sessions, live interaction with presenters and attendees, downloadable session materials and much more.
Click here to Register! | |
|
Featured/New Products For Your Review
The following products are in the Product Directory, and may help in your use of your database engine. Take a look when you get
a minute.
* Hedgehog EnterpriseTM -
Database Activity Monitoring and Intrusion Prevention
* EMC2IP Storage Solution -
Simple, affordable, IP Storage Solutions
Find out about these and other products in the Product Directory.
|
|
Continuous Data Protection by Dell EqualLogic Daily data backups are an important, yet painful, operation slowing (even halting) production, requiring hands-on management, and consuming media. Recovery is even more painful finding the right backup media and restoring data back into a usable format can take hours, and even days. Learn more about increasing backup frequency and fidelity without interrupting production operations - Download this whitepaper now!
|
|
|
Attend the SSWUG Ultimate Virtual Conference! Presenting the largest online learning event covering Business Intelligence, SQL Server, Sharepoint and .NET Development November 5, 6 and 7. Twelve simultaneous tracks featuring over 40 well-known industry experts! Broadcast quality sessions, live interaction with presenters and attendees, downloadable session materials and much more.
Click here to Register!
|
|
Today's Articles
Note: 'Guest' articles below will be available for seven days to registered guests.
SQL Server Topics
Developer Topics
Oracle Topics
XML Topics
DB2 Topics
SSWUG.ORG Sponsors, Special Offers
| |
Thank you to our sponsors!
Special Member Offers
See the special member offers page for more information
Pay them a visit and let them know you heard about them on SSWUG.ORG!
|
SSWUG.ORG Free Software
| |
Software Free to use courtesy of SSWUG.ORG
- SQLsafe Freeware Edition - High performance SQL Server Backup & Recovery – 50% Faster than Native Backup Idera SQLsafe Freeware Edition is a free SQL Server database backup and...
- Free SQL Server Performance Dashboard - Idera Free SQL Check SQLcheck is an easy-to-use performance dashboard for SQL Server. Running as a handy and secure screensaver or on-demand, SQLchec...
- Free SQL Server Permissions Transfer - Idera SQLpermissions Save time and reduce errors when setting up SQL Server logins & permissions. SQLpermissions will generate customizable T-SQL sc...
Free Software Offers
See the free software page for more information
|
Summaries
Guest Articles [Top]
The article listings denoted as GUEST are random archive articles. Those articles are always available to dues-paying members, but are also available to guest newsletter subscribers for a period of 7 days from the release of this newsletter. Each newsletter features a new set of archive articles for each of the topics.
It's our hope that when you see the quality and range of articles in the archives, you'll see what a great value your SSWUG dues-paying membership really is.
Click Here to Activate Membership Today - it only takes a minute.
[ SQL Server ]
[ Oracle ]
[ DB2 ]
[ Open Source ]
[ XML ]
[ Developer ]
[ Join/Upgrade ]
[ Webcasts ]
[ Podcasts ]
[ Newsletter Archive ]
[ RSS/Feeds ]
[ About ]
[ Advertise ]
[ Contact ]
[ Privacy ]
[ Terms of Service ]
[ Link to SSWUG ]
[ List Server Archives ]
[ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.
Some names and products covered by SSWUG are the registered trademarks of their respective owners.
The SQL Server Worldwide User's Group
8987 E. Tanque Verde #309-269
Tucson, AZ 85749 USA
|
