locked
Troubleshooting SSRS RRS feed

  • Question

  • Hi,

    I am new to SSRS. I am working as a MS SQL production DBA.

    Normally where SSRS error logs stores and what is procedure for troubleshooting. I mean troubleshooting methodology.

    What is the DBA role in SSRS?
    Tuesday, April 8, 2014 12:45 AM

Answers

  • >>>What is the DBA role in SSRS?

    Configure SSRS service

    Backup Report database

    Optimize queries that generate Reports


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Tuesday, April 8, 2014 5:42 AM
  • The log files are at:

    %ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles

    where %ProgramFiles% is the language specific name of the program files folder and MSSQL.x depends on the version you have installed

    Tuesday, April 8, 2014 11:45 PM
  • For the location of the logs files :

    C:\Program Files\Microsoft SQL Server\MSRS10.SQL2008\Reporting Services\LogFiles

    You need to change C:\ with your drive installation and 10.SQL2008 with version and the instance name of your SSRS service.

    For the DBA role in SSRS is :

    1. Use for example the maintenance plan to backup and restore the SSRS Databases, beacause SSRS use two DataBases.
    2. Manage the security, for example add a new user to view the reports, or create a custom group for SSRS that have some rights like manage the subescriptions.
    3. Log the queries that consumes the resources by Activity Monitor or SQL Server profiler.
    4. Suggest the perfect indexation the query that consumes resources by SQL Server profiler and Data Tunning Advisor
    Wednesday, April 9, 2014 12:03 AM

All replies

  • >>>What is the DBA role in SSRS?

    Configure SSRS service

    Backup Report database

    Optimize queries that generate Reports


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Tuesday, April 8, 2014 5:42 AM
  • The log files are at:

    %ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles

    where %ProgramFiles% is the language specific name of the program files folder and MSSQL.x depends on the version you have installed

    Tuesday, April 8, 2014 11:45 PM
  • For the location of the logs files :

    C:\Program Files\Microsoft SQL Server\MSRS10.SQL2008\Reporting Services\LogFiles

    You need to change C:\ with your drive installation and 10.SQL2008 with version and the instance name of your SSRS service.

    For the DBA role in SSRS is :

    1. Use for example the maintenance plan to backup and restore the SSRS Databases, beacause SSRS use two DataBases.
    2. Manage the security, for example add a new user to view the reports, or create a custom group for SSRS that have some rights like manage the subescriptions.
    3. Log the queries that consumes the resources by Activity Monitor or SQL Server profiler.
    4. Suggest the perfect indexation the query that consumes resources by SQL Server profiler and Data Tunning Advisor
    Wednesday, April 9, 2014 12:03 AM