1-10 of 12 < Previous Next >
1 vote

Master Package exited with error

Upon running the Query Hash Statistics Collection set, I received the following error message in the Collection set log. SSIS error. Component name: GenerateTSQLPackageTask, Code: -1073548540, S...

id# 12 | Planned Release: None | 1 comments | Last Updated: Oct 30 2013 at 9:58 PM  by Evadman
1 vote

Error converting data type nvarchar to smallint

Whenever I try and load click the link to QueryHashStats I get the following error An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'TopQue...

id# 11 | Planned Release: None | 0 comments | Last Updated: Aug 23 2013 at 2:54 PM  by jroyale007
1 vote

Minimally-privileged users can't exec reporting procs

The MDW schema install script creates two reporting procs in the customsnapshots schema. The system-created mdwreader role has SELECT permission on this schema, but doesn't have EXEC permission. Th...

id# 10 | Planned Release: None | 0 comments | Last Updated: Mar 5 2013 at 10:40 PM  by bartd
1 vote
closed

uspcollectqueryhashstats - Arithmetic overflow error converting expression to data type smallint.

Issue reported in discussions: ----------------------- Hi I'm trying to install the Query Hash Statistics Collection on a SQL 2008 R2 sp1 and I get this error Msg 8115, Level 16, State 2, Pro...

id# 9 | Planned Release: QueryHashStats v0.14 | 0 comments | Last Updated: Feb 23 2013 at 1:58 AM  by bartd
1 vote
closed

Wrong Databases Displayed on Report

I have deployed the Query Hash Statistics solution to a client and they are seeing databases listed on some servers that are not on those servers. In the attachment, the highlighted database is no...

id# 8 | Planned Release: QueryHashStats v0.14 | 4 comments | Last Updated: Feb 23 2013 at 1:55 AM  by bartd
2 votes
closed

Database name reported incorrectly

Sometimes, I noticed that database name is reported incorrectly for query hash statistics report where as I click on specific query, then it shows a different database name. Probably something wron...

id# 7 | Planned Release: QueryHashStats v0.14 | 3 comments | Last Updated: Feb 23 2013 at 1:54 AM  by bartd
1 vote
closed

Deleted all history after stop data collection

Hi, I've stopper data collection Query Hash Statistics and I would like to purge the tables in msdb and mdw databases to reclaim space. How can I do? Can I run Truncate on the tables? Tables: m...

id# 5 | Planned Release: None | 1 comments | Last Updated: Feb 22 2013 at 2:47 AM  by bartd
4 votes
closed

Invalid object name 'core.snapshots'

When I try to run the report I get this message Invalid object name 'core.snapshots' I have done all the steps mentioned to make the installation and got no errors during it. My server is a SQL...

id# 6 | Planned Release: None | 1 comments | Last Updated: Feb 22 2013 at 2:46 AM  by bartd
2 votes

Proxy accounts or non-default data retention periods are lost when the target script is executed

If you configure the collection set to run under a proxy account or to use a non-default data retention period, that must be repeated whenever you execute the QueryHashStatsSetupTarget.sql script. ...

id# 4 | Planned Release: None | 0 comments | Last Updated: Jan 7 2011 at 9:36 PM  by tshostak
1 vote
closed

FK on plan/text table can block scheduled MDW data purging

There's a FK on the queryhashtextandplan table that references the MDW snapshots table. This FK does not have ON DELETE CASCADE, which is expected because the data in this table should be long-liv...

id# 2 | Planned Release: QueryHashStats v0.12 | 2 comments | Last Updated: Dec 9 2010 at 2:27 AM  by bartd

Configure View

Search
Sort by Id
Release
Title
Updated
Votes
1-10 of 12 < Previous 1 2 Next >
Updating...
Page view tracker