Viewing 15 posts - 3,361 through 3,375 (of 5,843 total)
Given your lack of knowledge and experience on SQL Server, if you want this process to run efficiently you will need to get some mentoring on board to help you...
May 31, 2011 at 12:32 am
1) the advise to make tempdb files equal to CPU cores is overblown. virtually no one out there has sufficient IO throughput to feed up 8, 16, 32, 64,...
May 31, 2011 at 12:29 am
Get a copy of Adam Machanic's free sp_whoisactive (v11.00 is current I think). READ THE DOCUMENTATION at the top of the sproc code!! AWESOME STUFF!
May 31, 2011 at 12:23 am
1) Syed - this person stated they have 100 rolling days of data (day comes in, one drops off). Why would you recommend YEARLY partitioning??
2) Partitioning CAN be great...
May 31, 2011 at 12:21 am
qur7 (5/27/2011)
how to use spotlight to solve and all or to find out what is the issue that is causing the queries to suddenly run slow.Thanks in Advance
1) RTFM...
May 30, 2011 at 9:22 am
what type of plan are you getting?
are you filtering any rows or doing stuff (aggs?) with all 700M of them?
Sounds like an interesting problem, although I will say...
May 27, 2011 at 3:09 pm
I note that you never stated WHY you are even considering a refactor? Is your existing query slow? And if so, have you done the following:
1) wait stats...
May 27, 2011 at 1:17 pm
Perhaps this is a multi-threaded insert by SSIS, in which case rows can be interspersed and thus lead to nasty frag? Try forcing single thread.
Also, given width of actual...
May 26, 2011 at 9:53 am
You have been working at this for 4 days now. Get a performance tuning professional to give it a review and you should be able to see significant improvements...
May 26, 2011 at 8:16 am
1) You have been working on this for 6 days now! Get a performance tuning pro on your system and it shouldn't take more than a few hours to get...
May 26, 2011 at 7:23 am
1) sp_msforeachdb IS documented - you can generate the script of it's code and there is your documentation. You can also fix it with your own improvements.
2) ola.hallengren.com's stuff...
May 26, 2011 at 7:18 am
This is a VERY common scenario - just saw it yet again at a client earlier this week. If you have many NULLable variables and/or tables that you join...
May 26, 2011 at 7:16 am
For THIS poster's table (which has PK on identity) I agreed that your statement was correct. But it is NOT generally applicable, and many people read these forums and...
May 20, 2011 at 7:59 am
No one has mentioned doing a file IO stall and wait stats analysis while the process is running. You need to do that to find out exactly what the...
May 20, 2011 at 7:02 am
Just a suggestion: If all of your I/O activity on the table consists of insertions of new records and deletions of old records, I would consider setting the fill factor...
May 20, 2011 at 6:51 am
Viewing 15 posts - 3,361 through 3,375 (of 5,843 total)