tag:blogger.com,1999:blog-1619266374223964354.post3475689569640339700..comments2024-03-17T08:06:29.007-07:00Comments on SQL and SQL only: Database Server is slow. Can you please check?Nagaraj Venkatesanhttp://www.blogger.com/profile/17134038987463298279noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1619266374223964354.post-13738752996303181992010-02-27T01:06:11.064-08:002010-02-27T01:06:11.064-08:00Hi,
Thank you. High values of paging and memory st...Hi,<br />Thank you. High values of paging and memory stress can be checked using the counters Memory:Pages/Sec,Buffer Cache hit ratio. I will be covering the same in my next post coming up in 2 days.<br /><br />On objects using tempdb, if you are on SQL 2005, DMV sys.dm_db_task_space_usage can help. But if on SQL 2000 there is no easy way of doing it. But anyways, I will present the options available on 2000 and 2k5 on my next few posts.Nagaraj Venkatesanhttps://www.blogger.com/profile/17134038987463298279noreply@blogger.comtag:blogger.com,1999:blog-1619266374223964354.post-20739895324231412572010-02-26T01:04:35.551-08:002010-02-26T01:04:35.551-08:00Hi,
Good post at the right time for me. Please co...Hi,<br /> Good post at the right time for me. Please could you also suggest ways for checking a high value of paging. Is there any way in which I can find the list of objects & their size using tempdb, or can I log the same into some file.Anonymousnoreply@blogger.com