Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLSERVER Mem usage
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
SQLSERVER Mem usage
Environment versions
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00981381
Message ID:
00981381
Views:
67
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
Map
View

Click here to load this message in the networking platform