InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 11:55:55 GMT20http://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspx[quote][b]Fraggle-805517 (9/6/2012)[/b][hr]General question on this really old post. Has anyone updated this to use 2012 yet? I have it on my 2005 system, but we just upgraded to 2012. Being blunt, I am lazy and wanted to ask before spending time trying to figure everything out.Fraggle[/quote]Hi,I have a SQL-2008 version, if you are interested.Haven't updated to 2012 yet.Sun, 09 Sep 2012 07:33:18 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspxGeneral question on this really old post. Has anyone updated this to use 2012 yet? I have it on my 2005 system, but we just upgraded to 2012. Being blunt, I am lazy and wanted to ask before spending time trying to figure everything out.FraggleThu, 06 Sep 2012 13:59:41 GMTFraggle-805517http://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspx[quote][b]scotta_miller (3/23/2009)[/b][hr]Figured out the issue. I didn't understand that when the report runs you have to click one of the text boxes along the top to view data. I guess I am used to seeing data populate when the report is ran. I changed the default Flag value to 1 so when the report runs, data is always populated for the default server and then subsequent servers as you click through them. Thanks for your help, you may consider outlining this or defaulting the Flag to 1. [/quote]Yes, thank you for pointing this out. In fact, come to think of it, I should have designed the report so that it opens up for the default server to save the user from doing additional clicks. Glad it is now working for you.Mon, 23 Mar 2009 17:15:14 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspxFigured out the issue. I didn't understand that when the report runs you have to click one of the text boxes along the top to view data. I guess I am used to seeing data populate when the report is ran. I changed the default Flag value to 1 so when the report runs, data is always populated for the default server and then subsequent servers as you click through them. Thanks for your help, you may consider outlining this or defaulting the Flag to 1. Mon, 23 Mar 2009 14:53:09 GMTscotta_millerhttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspx[quote][b]scotta_miller (3/23/2009)[/b][hr]The chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value &gt; 0, false, true) --- I tried setting the hidden property to false and got the same result. I double checked the DB and there are two table with no data: ExecRequestsTempdbSpaceUsage_Mean_StdDev[/quote]No problem, we will get to the bottom of this one way or another... :-)Mon, 23 Mar 2009 13:53:55 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspxOk, Thank you for your help.... :)Mon, 23 Mar 2009 13:50:04 GMTscotta_millerhttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspx[quote][b]scotta_miller (3/23/2009)[/b][hr]Both, it is blank locally and on the report server.[/quote]I will run the Supp Material code later today and see if I can reproduce the issue. Will send out an update later.Mon, 23 Mar 2009 13:48:19 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspxBoth, it is blank locally and on the report server.Mon, 23 Mar 2009 13:31:02 GMTscotta_millerhttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspx[quote][b]scotta_miller (3/23/2009)[/b][hr]The chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value &gt; 0, false, true) --- I tried setting the hidden property to false and got the same result. I double checked the DB and there are two table with no data: ExecRequestsTempdbSpaceUsage_Mean_StdDev[/quote]The fact that these 2 tables are empty just means that there have been no major peeks in the number of version-store/mixed-extent pages during this time. I forgot to ask you, are you having this problem in BIDS or IE or both?Mon, 23 Mar 2009 13:27:26 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspxI manually ran the job and then checked the log file and the job has been running every hour since I created it last Friday. Same thing with the Monitor job - it has been running every minute since last Friday.Mon, 23 Mar 2009 13:07:10 GMTscotta_millerhttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspx[quote][b]scotta_miller (3/23/2009)[/b][hr]The chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value &gt; 0, false, true) --- I tried setting the hidden property to false and got the same result. I double checked the DB and there are two table with no data: ExecRequestsTempdbSpaceUsage_Mean_StdDev[/quote]I think I know what may be wrong. Pls start the job titled "DBA - Tempdb Usage - Calculate Stats, Prune Tables". This job must run at least once before you start collecting data. I need to make sure this step is added to the SuppMaterial readme doc.I hope this solves the problem, if not, pls let me know.Mon, 23 Mar 2009 12:57:53 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspxThe chart visibility is based on the following expression: =iif(Parameters!chartFlag.Value &gt; 0, false, true) --- I tried setting the hidden property to false and got the same result. I double checked the DB and there are two table with no data: ExecRequestsTempdbSpaceUsage_Mean_StdDevMon, 23 Mar 2009 12:52:13 GMTscotta_millerhttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspx[quote][b]scotta_miller (3/23/2009)[/b][hr]Reporting Services 2005 and all servers are SQL 2005. I followed the doc included in the zip file. In reporting services The servernames Dataset returns the correct server name, I checked and the default servername is setup in the report parameters. I had to mod the Credentials setting to use windows authentication for the dymanic connection. I have tried setting all the datasets to use the AppDB.rds and statically assign the single server and still the report is blank. If I copy the Stored procs from the data tab and run them in SQL they return data .EXEC [dbo].[rpt_Tempdb_Occurrences_LowestNumberUnallocatedExtentPages] @Top = 20 --- Returns 16 recordsEXEC [dbo].[rpt_Tempdb_Occurrences_HighestNumberVersionStorePages] @Top = 20 --- Returns 20 recordsEXEC [dbo].[rpt_Tempdb_Occurrences_HighestNumberMixedExtentPages] @Top = 20 --- Returns 20 recordsI have created the Utility DB and I put the TempdbSpaceUsage_ServerNames table inside that DB, I have ran all the scripts to create the table and stored procs along with the JOB Script. I am not sure what I did wrong. Please let me know what additional information you need???[/quote]Hmm, I'm not sure what's wrong. I will have a look at the supp material I posted and retrace all the steps mentioned in the readme doc. I may have missed something. Can you check whether the visible property is set to true for the chart?Mon, 23 Mar 2009 12:46:45 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspxReporting Services 2005 and all servers are SQL 2005. I followed the doc included in the zip file. In reporting services The servernames Dataset returns the correct server name, I checked and the default servername is setup in the report parameters. I had to mod the Credentials setting to use windows authentication for the dymanic connection. I have tried setting all the datasets to use the AppDB.rds and statically assign the single server and still the report is blank. If I copy the Stored procs from the data tab and run them in SQL they return data .EXEC [dbo].[rpt_Tempdb_Occurrences_LowestNumberUnallocatedExtentPages] @Top = 20 --- Returns 16 recordsEXEC [dbo].[rpt_Tempdb_Occurrences_HighestNumberVersionStorePages] @Top = 20 --- Returns 20 recordsEXEC [dbo].[rpt_Tempdb_Occurrences_HighestNumberMixedExtentPages] @Top = 20 --- Returns 20 recordsI have created the Utility DB and I put the TempdbSpaceUsage_ServerNames table inside that DB, I have ran all the scripts to create the table and stored procs along with the JOB Script. I am not sure what I did wrong. Please let me know what additional information you need???Mon, 23 Mar 2009 12:42:48 GMTscotta_millerhttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspx[quote][b]scotta_miller (3/23/2009)[/b][hr]Thanks, for a Great article. I am trying to implement this on a test server and the report shows no data at all (Except the server name). When I run the stored procs by them selves I get data back. Any idea why the report is blank?[/quote]Thank you!Are you running it on SQL-2008 Reporting Services? If yes, pls have a look at the bottom of the article (last figure), where I'm discussing a similar issue I was having when I migrated the app from SQL-2005. If you are running it on SQL-2005 SSRS, I will need more info to troubleshoot on.Mon, 23 Mar 2009 12:26:49 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspxThanks, for a Great article. I am trying to implement this on a test server and the report shows no data at all (Except the server name). When I run the stored procs by them selves I get data back. Any idea why the report is blank?Mon, 23 Mar 2009 12:17:40 GMTscotta_millerhttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspx[quote][b]mishaluba (3/21/2009)[/b][hr]Thank you for the article and detailed solution. I had no idea that RS reports could be made so interactive using "Actions". Learning something every day![/quote]Thanks! Have a look at the new sql-2008 feature of performance data collection and the reports that ship with it. It will give you an even better idea on what is possible with Reporting Services.Sun, 22 Mar 2009 05:40:46 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspxThank you for the article and detailed solution. I had no idea that RS reports could be made so interactive using "Actions". Learning something every day!Sat, 21 Mar 2009 19:38:42 GMTmishalubahttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspx[quote][b]Rick Romack (3/16/2009)[/b][hr]Great article and I can already see many uses. One thing I did find is that the tSQL scripts to install the jobs assumes that the SA account has not been renamed. On All our servers we rename that account even though we use Windows Only Authentication. I simply edited the script and changed the SA account to the account we use.[/quote]Thank you and good point.Mon, 16 Mar 2009 17:12:38 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspxGreat article and I can already see many uses. One thing I did find is that the tSQL scripts to install the jobs assumes that the SA account has not been renamed. On All our servers we rename that account even though we use Windows Only Authentication. I simply edited the script and changed the SA account to the account we use.Mon, 16 Mar 2009 13:05:50 GMTRick Romackhttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspxUnfortunately, some of the figures are not clear enough. I will make sure I make them larger for the next article. :)Please have a look at the supp. material, and, hopefully, that will make the discussion and figures clearer.Mon, 16 Mar 2009 05:23:04 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic675971-1399-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/tempdb+utilization/65149/">Real-Time Tracking of Tempdb Utilization Through Reporting Services</A>[/B]Sat, 14 Mar 2009 13:58:46 GMTMarios Philippopoulos