July 14, 2011 at 9:22 am
What does SELECT @@version return?
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
July 14, 2011 at 9:43 am
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
July 14, 2011 at 9:52 am
can you relate your case with this SP1 fix ?
649391 DBCC corruption errors occur during SQL Server 2008 R2 collations when strings that have Jamo sequences that follow the Japanese prolonged sign are used.
full fix list http://support.microsoft.com/kb/2528583
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 15, 2011 at 8:27 am
I would say to stop using maintenance plans altogether. Get the awesome free mx package from ola.hallengren.com
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
November 1, 2016 at 4:01 am
The problem was that for this particular server we had sent the CPU and IO Affinity masks so that the SQL Server would not take up all the CPU processing. Changing the SQL Server properties under the Processor page to use all processors for CPU and IO appears to have fixed the problem.
November 1, 2016 at 8:58 am
In 20+ years of consulting on the SQL Server relational engine at all kinds of scale I can count on one hand the number of times it was REALLY OPTIMAL to mess with any of the various affinities.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply