Viewing 15 posts - 91 through 105 (of 114 total)
Just a last question to this topic : Now I know more about indexing and reading maintenance plans. But how do I start my "performance tuning weeks"? IS it the...
February 5, 2013 at 7:49 am
Ok. But the real question is, if I would need some of the clustered virtual volumes though, which are at the moment bound to the old cluster, how could I...
February 5, 2013 at 3:32 am
Hi Jeffrey,
thanks for your answer. I thought it's all in the text...
...we had Windows Server 2008 Enterpise 32Bit which we upgraded to 2008 R2 64Bit.
Greetz
sql pizza
February 5, 2013 at 1:04 am
Hi Drealith,
first of all...if you click on the edit-button you can always edit your last posting and don't need to double- or triple post.
If you chose another Database to log...
February 5, 2013 at 12:59 am
Richard Fryar (2/4/2013)
Why create a new database? You could have just detached, copied files and attached again. The MDW collectors would have continued using the same database.
Exactly!
Just stop...
February 4, 2013 at 6:47 am
If you installed explicitly in the same directy, having same instance name, the best thing would be to just disable the 2005 services.
If anybody has a diffrent opinion bout this....
February 4, 2013 at 5:45 am
Why don't you just query the new MDW-Database and take a look a the timestamp of the latest entries?
Greetz sql pizza
February 4, 2013 at 5:41 am
Thanks Gail for this nice article. Ok, nevertheless : troubleshooting performance should be a long term process and usually you have to concern different factors and can't make a decision...
February 4, 2013 at 5:33 am
Did you choose a different installation directory?
Did you try to uninstall it via Programs and features? (Start -> Control Panel -> Programs and Features -> SQL Server 2005 -> uninstall)
Greetz...
February 4, 2013 at 5:19 am
sqlfriends (2/1/2013)
Sorry, I mean Total server memory is much lower than target server memory.Does it indicate a memory pressure?
Ok. Now I understand quite a bit more what you want to...
February 4, 2013 at 5:11 am
Hi sqlfriends,
as you've already learned, memory management in sql server is a very complicated topic. Could you please describe your problem more precise, to give us a chance to better...
February 1, 2013 at 12:45 pm
Let me guess. You got "lock pages in memory" enabled?
Use the DMV sys.dm_os_process_memory ( select (physical_memory_in_use_kb / 1024) AS total_mem_usage_MB from sys.dm_os_process_memory ).
For a detailed view use sys.dm_os_memory_clerks ( select...
February 1, 2013 at 1:23 am
If SQL is still taking 100% of the CPU, then you haven't tuned all the CPU consuming queries. Keep going, not something you're going to solve in 5 minutes, usually...
January 31, 2013 at 7:16 am
So now as I tuned all my CPU-extensive queries, I must state, that SQL Server is still taking almost 100%.
What else can I do? How can I see explicitly how...
January 31, 2013 at 6:12 am
Viewing 15 posts - 91 through 105 (of 114 total)