Administrating SQL Server Reporting Services - Planning, Documenting and Troubleshooting

RIL_button( “http://sqlconcept.com/2011/11/22/administrating-sql-server-reporting-services-planning-documenting-and-troubleshooting/”, “Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting” );

I just had another article published at simple-talk.com: “Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting“.

The article is a deep dive into the configuration, security and performance of SSRS and is closely related to the SSRS Performance Dashboard which I recently

Continue reading [...] Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting [...]

November 22nd, 2011 | Tags: , , , , , , , , , , , , , | Category: SSRS, T-SQL | Comments are closed
Work on itWell, now...OKGoodGood job! (3 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

'Database name' as a delimiting factor for SQL Server perfmon counters

RIL_button( “http://sqlconcept.com/2011/05/19/database-name-as-a-delimiting-factor-for-sql-server-perfmon-counters/”, “‘Database name’ as a delimiting factor for SQL Server perfmon counters” );

As a further reading after the performance tuning in shared secure environment, I am posting a list of SQL Server perfmon counters which take ‘database name’ as a delimiting parameter.

\SQLServer:Databases(database_name)\Active Transactions

Number of active update transactions for the database.

[...] ‘Database name’ as a delimiting factor for SQL Server perfmon counters [...]

May 19th, 2011 | Tags: , , , , , | Category: Performance audit | One comment - (Comments are closed)
Work on itWell, now...OKGoodGood job! (3 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

Performance tuning in a secure shared SQL Server environment

RIL_button( “http://sqlconcept.com/2011/05/19/performance-tuning-in-a-secure-shared-sql-server-environment/”, “Performance tuning in a secure shared SQL Server environment” );

I received a very interesting question by email just now and I would like to give the answer here.

I am not sure if the author is OK with me quoting the entire question, hence I will paraphrase it:

We have our databases on a SQL

Continue reading [...] Performance tuning in a secure shared SQL Server environment [...]

May 19th, 2011 | Tags: , , , , , , , , , , , , , | Category: Performance audit, SQL Server Limitations, SQL Server metadata | 2 comments - (Comments are closed)
Work on itWell, now...OKGoodGood job! (1 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

 
  Older Entries »