Viewing 15 posts - 91 through 105 (of 115 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...
Greetz
Query Shepherd
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...
Greetz
Query Shepherd
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
Greetz
Query Shepherd
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...
Greetz
Query Shepherd
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...
Greetz
Query Shepherd
February 4, 2013 at 6:47 am
February 4, 2013 at 5:58 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....
Greetz
Query Shepherd
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
Greetz
Query Shepherd
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...
Greetz
Query Shepherd
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...
Greetz
Query Shepherd
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...
Greetz
Query Shepherd
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...
Greetz
Query Shepherd
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...
Greetz
Query Shepherd
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...
Greetz
Query Shepherd
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...
Greetz
Query Shepherd
January 31, 2013 at 6:12 am
Viewing 15 posts - 91 through 105 (of 115 total)