I am populating a catalog (which is taking longer than on 2000) and when I look at the processes what is see is strange... MSFTESQL has many spids and each spid appears to have 4 connections. Of each set of 4 3 are blocked by 1... This seems odd to me. Also the CPU is at 90%-100% but it is not the MSFTESQL service. It is the SQL server hogging it all.
I have looked but can't find anything. I found information on it MSFTESQL is talking all the CPU but that won't help me. SQL 2005 is the only thing on this server (win 2003)... It only had 3.5 gb of ram but it is just testing ground for our app...
Any guidence in what to look at or alter would be great...
Look like the current syntax "alter fulltext index" does not allow indexed hint, maxdop. This would be a good request to file.http://connect.microsoft.com/sql|||
Added a request as a bug.
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260917
No comments:
Post a Comment