General information
Title:
SQLSERVER Mem usage
Environment versions
Network:
Windows 2003 Server
Hi all,
I have a big problem with my SQL Server 2000 SP3a runing on Windows server 2003. When I use Openquery() with a linked server using .DBF table, the amount of Mem Usage in taskmanager for process sqlservr.exe is growing fast and never go down. After restarting SQLServer and 15 Openquery() request, mem usage pass from about 19,000K to about 510,000K. When Mem usage is about 800,000K the server doesn't respond anymore, connections are disconnected and the only way to use it again is restart the service.
Any help is welcome.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only