Viewing 15 posts - 616 through 630 (of 902 total)
thanks for the update matt,
thats curious, im sure we have several SQL2005 databases running on R2 without any issues, so I'm curious to know what they're going to do...
October 31, 2012 at 7:21 am
I didnt realise it was 3rd party code that you were looking at, in which case I would contact the 3rd party, rather than making a change, as it could...
October 31, 2012 at 7:17 am
no problem it will be nice to know what the problem was just for future reference.
October 31, 2012 at 6:43 am
It looks like the problem isnt with the Disks as they are performing very well, with low disk ques and fast responses.
It may be worth checking with the guys...
October 31, 2012 at 6:08 am
It seem that the server is running low on disk space are DB's, TempDb, Logs all on the same drive?
You might also want to try adding Where clauses to the...
October 31, 2012 at 5:49 am
hmm, ok so we know its not a problem with Parallelism, which is a good thing.
I take it you have rights to remote onto the server, if can you set...
October 31, 2012 at 4:20 am
Another option is to use SSIS or the Import wizard to pull the data over from the other server.
October 31, 2012 at 3:40 am
If you need an index look at creating a non-clustered index rather than a clustered index, with a high fill factor (90-95%) to prevent a large number of page splits...
October 31, 2012 at 2:05 am
Sorry for the late response Matt, I cant see much wrong with the server set up in terms of memory etc, I'm not a Virutal server expert but I have...
October 31, 2012 at 1:49 am
Thanks matt,
I take it that the SQL server is a 64bit box and doesnt have any throttling going on in terms of Max Degree of Parallelism, max memory usage.
How many...
October 30, 2012 at 9:50 am
Its a valid point about the number of Employees, and you could do a count against each employee for a given workplace.
It would depend on how frequently this number...
October 30, 2012 at 9:38 am
Are the boxes the same in terms of Memory, CPU's and disks?
October 30, 2012 at 9:25 am
Artoo22 (10/30/2012)
matt.gyton (10/30/2012)
The database was being transferred from a SQL 2005 server to a SQL 2008 R2 server. I have now determined, after...
October 30, 2012 at 9:12 am
Thanks,
Can you also post the query that you're running as it will help us understand the plan as well.
October 30, 2012 at 7:13 am
How big is the underlying data set?
If you have an order by it has to return all the data, sort it and then look at the top 100,000, where as...
October 30, 2012 at 5:10 am
Viewing 15 posts - 616 through 630 (of 902 total)