Viewing 12 posts - 1 through 12 (of 12 total)
Thank you for the responses guys.
So I have established I am being quoted an annual subscription license for SQL 2012 which does include SA at £4800 for a 2 core...
July 15, 2014 at 7:58 am
I re-ran my tests with hyperthreading disabled and there was no benefit at all. If anything times were very slightly slower for the single threaded powershell test, and noticeably slower...
June 19, 2012 at 10:41 am
I will get hyperthreading disabled today to see how that goes. In the meantime, I cleared the wait stats, ran a few test jobs in the application and the significant...
June 19, 2012 at 2:18 am
We have a HP DL360 G7 something like this link:
except with 24Gb RAM and 2 disk Raid1 for the Log drive and 6 disk RAID10 for the Data.
As far as...
June 18, 2012 at 4:31 am
I have encouraging news! The CPU powersaving mode was enabled and setting this to High Performance mode did improve performance significantly on the new box.
Rather than running the app each...
June 15, 2012 at 7:01 am
Hi Asit,
The server I am testing is brand new with nothing else running on it. There are definately no other processes running on it as I am the only...
June 15, 2012 at 1:59 am
I have confirmed that the application is using connection pooling by tracing the logon audit so it doesnt seem to be that.
The database is quite small, only 8 Gb, and...
June 14, 2012 at 9:06 am
Hi Grant,
I have done a cursory check of the settings on both servers and nothing different stands out. I did run a test with 'Optimise for Ad Hoc Workloads', but...
June 14, 2012 at 7:24 am
Thanks Satish,
1) Statistics were up to date, but I updated them again with FULLSCAN and there was no difference.
2) Indexes have less than 1% fragmentation so it's not that
3) The...
June 14, 2012 at 6:50 am
I think I may have found a workaround - if I restore a full backup of the database over itself it should fix the issue happening with future backups. I...
December 30, 2009 at 9:15 am
No, I have taken a backup during the day using t-sql and it has definitely not put the db into single_user mode during the backup.
December 30, 2009 at 6:16 am
It is definitely single_user.
I have performed the restore using the GUI, a script and via a common stored procedure we use for redgate backups across all our servers.
At this point...
December 30, 2009 at 4:40 am
Viewing 12 posts - 1 through 12 (of 12 total)