SQL Server Performance Forum – Threads Archive
How to fine List of PINTABLES
Hi ALL Is there any way How to fine List of Table Which are PINNED ? Regardscheck out OBJECTPROPERTY(Id, ‘TableIsPinned’)
YOu can use SP_TABLEOPTION for result also. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi bertcord, Many thanks, for ur reply I found out all pined table and i made it unpin But my sqlsvr.exe memory in task manager growing and growing when i restart the MSSQL svr
any idea why sqlsvr.exe is growing Regards
Srini
Run SP_WHO2 from QA and collect all other performance monitor counters such as cpu, physical disk, process, memory, sql server memory, user connections etc. for further assessment. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>