This is my first question about SQL Server, I'm new to SQL Server and I don't understand few things, so hope you can help me.
We got a SQL Server 2008 with 2 instances and also with Analysys Services installed (on same box).
The server is:
2 Quad core Xeon
The SQL Server instances are configured by default, but we got times where memory consumption is high and also high pagination is presented, does this means that the memory is incorrectly configured?
Do I need to make changes in the configuration?
Actually, I'm starting to administer SQL Server, so I don't understand many things, any help or document is welcome.