grooming does not seem to be working

FAQ

Profile

grooming does not seem to be working

Database Forums (Home) -> Data Warehouse

Next: Update Stats for procedure uses too much Virt mem..

Author

Message

SQLBatman

External

Since: Mar 23, 2009
Posts: 1

(Msg. 1) Posted: Mon Mar 23, 2009 9:40 am Post subject: grooming does not seem to be working Archived from groups: microsoft>public>sqlserver>datawarehouse (more info?)

our OpsMgrDW continues to grow, it has not leveled off in the past two years. we suspect that the grooming is not working correctly, but do not know of any way to see for ourselves. we are currently set to keep 400 days worth of info at most, so i suspect that some of the PerfHourly tables have not dropped off and could use some help in determining if the grooming process is indeed working. are there some log files i could examine for errors? is there some t-sql i could run to verify the process? >> Stay informed about: grooming does not seem to be working

Display posts from previous:

Related Topics:

Analysis Server Manager Not Working Properly - We have a Windows 2000 SP 4 server running SQL Server 2000 SP3 Enterprise Edition, and Analysis Server SP 1 (Version 8.0.382). Suddenly, the Analysis Server Manager seems to be acting weird. We go to the Cubes tree, and when you right click to edit the....

how to reduce PAGEIOLATCH_SH waits? - Hi, I have heavy updates and the most frequent problem is the PAGEIOLATCH_SH wait type. The update is blocked by himself (using the sp_who1, I see the lock) what can I do? there is any hint or option to test? which counter of performance I have to..

lot of CXPACKET wait types... - Hi again, my second problem is the CXPACKET wait type. during the execution of complex queries when the same table is used multiple times, I have some CXPACKET waits. My server is SQL 2000 Ent. SP4 with 4 proc. (with HT, so windows see 8 processors)...

Anyone know of any good AS performance tuning guides on th.. - Anyone know of any good AS performance tuning guides on the web?

how to improve data transfert througput? - Hi, How can I improve the communication and the data transfert betwee n 2 servers across a 1ghz LAN? I have a data warehouse on a server and my OLAP cubes on a second server. the data transfert never takes more then 5% of the 1gbps bandwidth My SQL..

	Database Forums (Home) -> Data Warehouse	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum