November 16, 2010 at 12:40 pm
Hi,
My problem is about, I have a SQLServer 2005 running normally, but unexpectedly it was very slow.
Only restart the server is than go normally.
In order words, it is very random.
I checked indexes, statistics, fill factor, but nothing resolved.
Thanks!
Fernando.
November 16, 2010 at 12:54 pm
You realize your question is sort of the same thing as "Why is my computer is running slow sometimes"? There could be any of about a zillion reasons this is happening.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 16, 2010 at 12:54 pm
Have you looked at performance monitor to see what is taking up time? Is it running into memory pressure issues?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 17, 2010 at 4:14 am
Today I'll go on the client, and will check the performance monitor. As the memory has been verified.
Thank's!
Fernando
November 17, 2010 at 4:20 am
Ok, I'll check the questions in the topic!
Thank's!
Fernando.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply