236 reputation
16
bio website stackoverflow.com
location United States
age 35
visits member for 3 years
seen Dec 5 at 19:03

(blank)


Oct
30
awarded  Revival
May
15
revised Master slave replication in mysql seconds behind master goes on increasing
edited body
May
15
answered Master slave replication in mysql seconds behind master goes on increasing
Apr
3
awarded  Yearling
Dec
4
revised Backup sql database directly to FTP server
added 445 characters in body
Jul
4
answered Greyed out menu options, broken activity monitor
Apr
4
answered Backup sql database directly to FTP server
Jan
15
awarded  Student
Jan
14
comment SQL Server Reporting Services Slow TotalTimeDataRetrieval Fast ExecuteReaderTime
Which code? The stored procedure is SELECT Column1, Column2, Column3 FROM SomeDatabase.dbo.SomeTable (NOLOCK) WHERE FilterId = @SomeIntParameter; The report RDL file itself is a simple tablix, a single dataset, and a single parameter. I've noticed the report execution is fine after the first execution completes for a user so long as the ExecutionId doesn't change even if they pick completely different parameter values. When digging through the AdditionalInfo column in ExecutionLog3, it shows the ConnectionOpenTime goes to almost nothing in the subsequent executions.
Jan
14
comment SQL Server Reporting Services Slow TotalTimeDataRetrieval Fast ExecuteReaderTime
Yes, statistics are updated multiple times a day on the underlying table that powers the report. This is not a query performance issue. This is something else.
Jan
14
awarded  Editor
Jan
14
revised SQL Server Reporting Services Slow TotalTimeDataRetrieval Fast ExecuteReaderTime
added 221 characters in body
Jan
14
comment SQL Server Reporting Services Slow TotalTimeDataRetrieval Fast ExecuteReaderTime
Yes. SQL Profile Traces show the stored procedures are taking milliseconds. Internal logging in the stored procedures show they are taking milliseconds.
Jan
14
asked SQL Server Reporting Services Slow TotalTimeDataRetrieval Fast ExecuteReaderTime
Jan
31
awarded  Teacher
Jan
30
answered SQL Analysis Services - SSAS
Dec
20
awarded  Supporter
Dec
20
awarded  Autobiographer