Hello again,
Is there any way to get what is really using the memory of my instance?
What should i check or what should i run on my instance to check what is really damaging performance inside SQL Server instance?
I know that i should use the performance monitor but i really don't know what points should i check without affecting the performance of my instance that its really bad.
Note: This is one SQL Server 2000 instance.
Thanks and regards.
JMSM 😉