SRS 2000 Report Usage Logging
Jan 16, 2007
I need to determine how often our SRS reports are being used. Is there any internal metric I can set and then check to find this out? We have a lot of reports and want to find out if some of them can be deleted for low usage. I understand SRS 2005 might have this capability but I have heard there's a way to do this in SRS 2000 as well.
If there is nothing internal to SRS 2000 that will do this, I wonder if anyone else has written some code to do this or has some ingenious method!
Thanks for any help!
View 1 Replies
ADVERTISEMENT
Jul 20, 2005
I am new to SQL Server 2000, I am looking to set up some type ofloging on out test database.I need to track what table are hit when a record is inserted via afront end piece of software (Struxure).Any help would be appreciated.Daniel KubicekSenior Programmer Analyst - Engineering & ProcurementGrede Foundries, Inc.414.256.9210Join Bytes!
View 1 Replies
View Related
Jun 21, 2007
Can you plz tel me where all dts information store in sql server 2000.
is it in the master databse in some table
thanks
sandipan
View 1 Replies
View Related
May 22, 2002
Hi,
I have a requirement to create a Database usage report. The report should have - userid, user name, login time, database to which he has logged in, log out time, host machine id.
How do I go about generating this type of report. What system tables are to be refered?
Please help.
Thanks
Sri
View 2 Replies
View Related
Aug 14, 2015
I have found a script which gives me disk size of all tables:
SELECT TOP 100
-- (row_number() over(order by (a1.reserved + ISNULL(a4.reserved,0)) desc))%2 as l1,
a3.NAME AS [schema]
,a2.NAME AS [table]
,a1.rows AS [rowCount]
[code]...
I was wondering if any has a script which will give me a similar report and a percentage figure of how much each table has grown since past week or month.
View 1 Replies
View Related
Jan 31, 2008
Does anyone have any reports built that show the usage of the reports based off the ExecutionLog table, or how you would get the "ReportID" to refer back to human readable report name?
I find it hard to believe others have not wanted to see how many reports were ran yesterday, what reports are not being used anymore, and which ones we may need to cache because they are over used throughout the day.
Thanks for any help!
View 3 Replies
View Related
Aug 2, 2007
We do have plenty of information about index usage in DMVs and I was wondering if there was any way for us to tell which of the user-created statistics for table were in use.
Any suggestions would be welcomed.
Thanks,
View 5 Replies
View Related
Feb 26, 2008
I'm trying to run the Disk Usage default report and am getting an error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
An error occured while rendering the report.
------------------------------
ADDITIONAL INFORMATION:
An error occurred during local report processing. (Microsoft.ReportViewer.WinForms)
------------------------------
The definition of the report 'Main Report' is invalid. (Microsoft.ReportViewer.Common)
------------------------------
An unexpected error occurred in Report Processing. (Microsoft.ReportViewer.Common)
------------------------------
Cannot execute a program. The command being executed was "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727vbc.exe" /noconfig @"C:Documents and SettingsAdministratorLocal SettingsTemp8vikhk2b.cmdline". (System)
Report has been running fine up until now. No changes that I'm aware of. Report runs fine on my laptop connecting to the server.
Update: This is happening with other reports as well. (i.e. Performance Dashboard)
View 2 Replies
View Related
Mar 23, 2006
Good day to all of you
I am faced SQL SERVER 2000 Memory usage problem. I am using Windows 2000 Server SP4 and SQL SERVER 2000 SP4. When User running some in-house application software, the memory for sqlservr.exe was increased . But, when user logout from the software. The sqlservr.exe did not decrease the memory. I have around 100 Users in my company. SQL Memory will countinues increase till max memory usage in CPU.
May i know how to order SQL SERVER need to purge memory when USER was log off from the Program? Or my SQL SERVER was corrupted /missing file?
Please advice
Many thanks!
Melvin
View 4 Replies
View Related
Jul 20, 2005
Hi All,I had two Window NT 4.0 Server, say A and B... We recently upgradedfrom MS SQL Server 6.5 to MS SQL Server 2000 on Computer A, and forComputer B, I installed SQL Server 2000 from scratch. These two have asame RAM(512MB) and CPU speed...so the setup for hardware is almostidentical...For server A, there are around 10 connection to this SQL Server...For server B, there are also around 10 connection to this SQLServer...The database for SQL Server B is a copy from SQL Server A.... Irestored the database on SQL Server B from the backup dump of ServerA...We have a store procedure called usp_GetMemo(ID Interger) ... we feedID number to this store procedure and return its return Description...this table has ID column and it's Non-Cluster index, allow theduplicate row... there are 1.7 million records for this table...Here is problem... whenever i execute more than 100 times for thisstore procedure(usp_GetMemo(ID)) continuously, the CPU usage ofComputer A is 3 times bigger than computer B....I did run the command "DBCC DBReindex" , "Update Statistics" for thistable on computer A, but did not make any difference...Keep in mind that Computer A has been upgraded to SQL server 2000while Computer B installed from scratch... would that make differencesomehow?? Before the upgrading, the CPU usage of computer A is thesame as Computer B...Any help will be really appreciated,Thanks alot,Kim,
View 7 Replies
View Related
Nov 21, 2001
The log for our SQL 2000 database shows constant "starting up database dbname" entires. Is there a option that causes the databases to constantly be starting or is this a new feature of SQL 2000.
View 1 Replies
View Related
Oct 26, 2007
I am trying to use a wildcard in a Filter condition within a SSRS - Report Builder report.
Are wildcards of anytime in fact allowed in this tool? I get errors when I try to use SQL-like wildcards such as '%'. I've also been unable to find any mention of "wildcards" in HELP.
Please help as soon as possible. THANKS!
View 7 Replies
View Related
Mar 15, 2007
I have used skiperrors parameter for 2601,2627 and 20598 errors in my Transaction replication setup. When transactions with above error are encountered, its skipped but I€™m not getting sql command that is skipped in MSrepl_errors table. Since SQL server 2000 is not saving transaction sequence number in the MSrepl_errors we are not getting the command, which have the errors.
Is there any way to track the commands those are skipped in transactional replication.
View 11 Replies
View Related
Aug 3, 2007
We have a SQL2000 database (Publisher) replicating inserts and updates across a 10Mb link to a SQL 2005 database (Subscriber). The Publisher has two tables we are interested in, 1 with 50 columns and 1 with 15. Both tables have 6 insert/update triggers that fire when a change is made to update columns on the publisher database.
We have set up a pull transactional replication from the Subscriber to occur against the Publisher every minute. We have limited the subscription/replication configuration to Publsih 6 columns from table 1 and 4 from table 2. Any change occuring on any other columns in the Publisher are of no interest. The SQL 2005 database has a trigger on table 1 and table 2 to insert values into a third table. There are around 7,000 insert/updates on table 1 and 28,000 on table 2 per day. All fields in the tables are text.
We are seeing "excessive" network traffic occuring of approximately 1MB per minute (approx 2GB per 24 hrs). We also see that the Distributor databases are getting very large -- upto around 30GB and growing until they get culled. We have reduced the culling intrval from 72 hrs to 24 hours to reduce the size.
Does anyone have any suggestions as to how this "excessive" network traffic can be minimised and how the distributor database size can be minimised. I think that maybe they are both related?
Thanks,
Geoff
WA POLICE
View 5 Replies
View Related
Jun 30, 2015
1. Does SSRS is J-Sox Compliant, an application must have audit trail feature. For Reporting printing, it should facilitate reports' data logging process.Â
2. Information like WHO and WHEN printed the report and WHAT data was viewed?
View 5 Replies
View Related
Jun 18, 2007
Greetings,
I am developing a package on my local workstation. I have defined two logging service providers. One is for SQL Server and the other is for the Windows Event Log. I am using the Dts.Log method in a script task to write log entries.
Logging is working properly with the SQL Server provider and rows are being inserted into the sysdtslog90 table. However, the only events that are being logged in the Windows Event Log are the package start and end events which I believe SSIS is doing automatically anyway.
Is there something I need to do to enable WIndows Event Log logging other than defining a log provider and making sure it is checked active? Won't SSIS write to two different logs with one Dts.Log call? Any ideas on what might be going wrong with my approach?
Thanks,
BCB
View 3 Replies
View Related
Oct 17, 2007
Hi,
I decided to use the SQL Server log provider to store logging data of all my Integration Services packages. I also created some reports about this data for operating purposes.
I have a problem occurs the name of the executing package is not always written to the log,but the name of the single task which failed. But that is not very useful information for operating, because I do not see any chance to get the name of the package by the information which is logged in the sysdtslog90 table in the database which I defined for SSIS Logging.
How do I configure the package to always log the package information into the table, too?
Best regards,
Stefoon
View 5 Replies
View Related
Oct 28, 2015
Is there a way to fetch database usage details for multiple SQL servers (report) usirng powershell script.
Details: servername, databasename, datafile usage, logfile usage, free % age...etc.
View 3 Replies
View Related
Nov 2, 2007
I have a client program that writes to sql server database 10 records per second . i want to compute the CPU usage and the memory usage for the whole program or CPU usage,memory usage for the insert statement in the program .
Can anybody help me with this?
View 6 Replies
View Related
Sep 7, 2007
Hello, When I am seeing SQL Server 2005 Management studio Server Dashboard> I am seeing my(USERS) databases and msdb database usage is very small % of in CPU Usage(%), Logical IO Performed (%) Usage pie chart.
90% of Total cpu usage is showing for Adhoc Queries. what excatly this means in Dashboard? if application uses more than it would have shown in Database level or not?
sicerely this dashboard is good, if any one is watching daily, please advice their experiences here.
Thanks in advance. Hail SQL Server!
View 3 Replies
View Related
Sep 12, 2005
I recently read the project real ETL design best practices whitepaper. I too, want to do custom logging as I do today, and also use SSIS logging. The paper recommended using the variable system::PackageExecutionId to tie the 2 logging methods together.
View 4 Replies
View Related
Mar 18, 2008
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
View 2 Replies
View Related
Mar 18, 2008
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
View 1 Replies
View Related
Jan 15, 2007
Using MS SQL 200 SP4 with Reporting Services 2000 SP2 on Win 2003 Server SP1
Visual Studio .NET 2003 on different PC (Win XP SP2)
No problem creating reports or building solutions.
Problems develop when deploying report to Report Server.
Here is the Output:
------ Build started: Project: From CD, Configuration: Debug ------
Build complete -- 0 errors, 0 warnings
------ Deploy started: Project: From CD, Configuration: Debug ------
Deploying to http://<server name>/ReportServer?%2f2nd
Deploying data source '/2nd/AdventureWorks2000'.
Deploying report 'Vendor Purchase Orders'.
The report definition is not valid. Details: Could not find schema
information for the element
'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Report'.
Deploy complete -- 1 errors, 0 warnings
---------------------- Done ----------------------
Build: 1 succeeded, 0 failed, 0 skipped
Deploy: 0 succeeded, 1 failed, 0 skipped
These are my first attempts using report services. In a previous deployment
attempts it created the folder (named 2nd), but in another attempt (saving it
to the existing folder) I got the same result as you see above (I have also
tried with a new folder but no luck). This above output is from my last
attempt.
The Build error Task List states:
The Report Definition is not valid. Details: Could not find schema
information for the element
'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:report'.
The shema URL as above returns HTTP 404.
If I remove :report, I receive the page for Report Definition Language
Schema May 2004
Looking at the .rdl code the schema URL is as above without :report.
As you can imagine with a limited skill set in this area I am quite
confused. I have been doing alot of research but found nothing to help (or
that I understand will help) so far.
If anyone can help me get through this I would appreciate it.
Bill
View 1 Replies
View Related
Feb 1, 2004
Hi All,
I had two Window NT 4.0 Server, say A and B... We recently upgraded from MS SQL Server 6.5 to MS SQL Server 2000 on Computer A, and for Computer B, I installed SQL Server 2000 from scratch. These two have a same RAM(512MB) and CPU speed...so the setup for hardware is almost identical...
For server A, there are around 10 connection to this SQL Server...
For server B, there are also around 10 connection to this SQL Server...
The database for SQL Server B is a copy from SQL Server A.... I restored the database on SQL Server B from the backup dump of Server A...
We have a store procedure called usp_GetMemo(ID Interger) ... we feed ID number to this store procedure and return its return Description... this table has ID column and it's Non-Cluster index, allow the duplicate row... there are 1.7 million records for this table...
Here is problem... whenever i execute more than 100 times for this store procedure(usp_GetMemo(ID)) continuously, the CPU usage of Computer A is 3 times bigger than computer B....
I did run the command "DBCC DBReindex" , "Update Statistics" for this table on computer A, but did not make any difference...
Keep in mind that Computer A has been upgraded to SQL server 2000 while Computer B installed from scratch... would that make difference somehow?? Before the upgrading, the CPU usage of computer A is the same as Computer B...
Any help will be really appreciated,
Thanks alot,
Kim,
View 7 Replies
View Related
Jan 30, 2014
providing a query for fetching the data for CPU Usage, Memory usage, blocking and all details ...
I want to create a job which will run on a Node every 15 min and store data in a table for each instance...
DMV is not giving more stuff and xtended events not sure if i can store that data into a table?
View 7 Replies
View Related
Jan 10, 2008
Hi..
I have made a big mistake. I was suppose to make a report for SQL 2000 but I made it in 2005. Now the Reporting server does not take the report. Obviously, as suggested in other topic here that 2005 report wont work on 2000 server.
Is there any way of converting this report from 2005 to 2000 so that I dont have to redesign it again.
thanks.
View 3 Replies
View Related
Jul 20, 2005
hiCould someone please help me in following:I need to update Policy status base upon commencement date and thenprint with new Policy status.I written a stored procedure to update the policy.Now I need to work out how I can print a report. We already doing thereport manually in our VB6 program but this is automatic process. So nousers involve here. It would change the status by running the storedprocedure and then print the report.Would it be possible execute the VB6 program via stored procedure?Would it be possible SQL 2000 produce a report?We used active-x dll in our VB6 program, is it any way can call dll filevia stored procedure?thank you.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Jul 20, 2005
hiHow I could print a report on printer using SQL 2000?I am not going in detail about the report as at the moment I need toknow how produce reports on printer.Thank you*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Feb 25, 2008
I have a report that feeds the data from SQL 2000 and its giving me this error:
Failed to retreive data from the database.
Details: ADO Error Code: 0x80004005
Source: Microsoft OLE DB Provider for SQL Server
Description: [DBNETLIB][ Connection Open (Connect ()).] SQL Server does not exist or access denied.
SQL State:08001
Native Error: 17 [Database Vendor Code: 17]
I test the database and its ok, we update both Crystal and SQL and nothing happend. We test communication from PC to server and everything looks OK. We check ODBC Settings and looks fine...
Thanks in advance
View 2 Replies
View Related
Aug 20, 2007
Just by using SQL Server 2000, what's the best way to run a stored procedure outputing the results to an excel sheet? I don't have Crystal Reports or any other 3rd party reporting tool to help me, a restriction of our client.
Found this http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1057989,00.html sp_write2Excel. Would this be the best way? Any other methods? The SQL server does not have MS Office so I think I need to ouput to a csv file.
View 2 Replies
View Related
Sep 9, 2007
Hi all
I am wondering if there is a solution for our current issue i.e. we can't export the query report from SQL report services into 2007 Excel.
We have no problem with Excel 2003.
Any help/reply would be much appreciated.
Cheers
View 9 Replies
View Related
Feb 26, 2008
Does anyone have a link to a good tutorial on how to create a drill down report in SSRS 2000. I found one for SSRS 2005
http://www.c-sharpcorner.com/UploadFile/MohanKumar.R/DrillDownReport02212008083910AM/DrillDownReport.aspx
If I had the AdventureWorks Db I may be able to figure it out.
I know how to create a hyperlink but I need the toggle (+/-) for my latest endeavor.
My book "Hitchhikers Guide..." didn't help me out.
Thanks.
View 3 Replies
View Related
