May 6, 2011 at 7:36 am
Hi
I am trying to SNAPSHOT a 20 million row report due to the long time spent rendering the unsnapped report.
Im using my best server:-
64 proccessors
62 gig ram
x64
If I try SNAPSHOT THE REPORT it just hangs and if I exec sp_who2 the spid is repeated about 20 times as suspended. However the on row of the spid is clocking cpu time.
The snapshot times out. "The user has cancelled the snapshot"
Any suggestions would be most wecome..
Andy
Andy.
May 6, 2011 at 7:58 am
Two steps back...
Why do you have a report showing 20 million rows? No one is ever going to read even 0.1% of that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2011 at 8:03 am
No one. However this is a Telco report on CDR's :- CALL DATA RECORDS.
WE HAVE BILLIONS OF ROWS IN OUR DATABASE. This is a small dataset with parameters. I need to SNAPSHOT the report but end users will use the parameters for smaller subsets of the data..
Andy.
May 6, 2011 at 11:22 am
Are you trying to capture the data somewhere like a staging table, or render it in a report? If the answer is render, pre-render or cache a report, just forget it. If you are having trouble putting the data into a staging area that a report will then draw from, that is a different conversation. Please clarify. Although I know what I mean when I say snapshot, it is not clear to me what you mean when you say SNAPSHOT.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply