HI, We still are in trouble, the PF Usage is big 6.75 GB. this continues to remain the same for more than 4 days. the phisical memory is 8GB. Do...
Hi, Yes I run the instcat.sql after I installed the SP4. Thanks a lot Entela
Hi, Thanks for the replay and I'm sorry i'm sending the mail too late. I tried the same you told me and I got the same error message: OLE DB...
HI, I run the VAS Scripts and I got these values: available memory in all free regions 3890148 KB get size of largest availble region 31168 KB...
Hi, Can you please send me again the VAS Scripts? Thanks a lot Entela
Hi Yes there is an application running. I saw the performance and I got the following: Pages/sec Average 0.00min 0.00max 0.00 Processor Time...
Hi, I didn't mention the counter at that time, because the SQL Server went down, and I run to change the node, The system should be running 24/7....
Hi, Actually I have enabled the Locked pages in memory, giving this right to the administrator (Should it be any specific user account) but after...
HI, Thanks for the e-mail. I saw the page file usage on task manager at performance tab. Before the error occured this parameter was less than 3.5...
Hi, I got a problem with the page file usage from SQL Server is getting bigger and bigger. We're using Intel(R) Xeon(TM) CPU 3.4GHz and 8GB of RAM,...
Hi, I'm using SQL Server 2000 with SP4 , and there is the same problem, I can't insert, update or delete from SQL Server 2005 64 bit into SQL Server...
Hi, Actually the problem is solved, the problem was the number of locks which was 5000. Since we updated the number of locks to 0, everythink worked...
HI, I have a problem with SQL Server 2005 Cluster configuration. I change the the resources from Node A to Node B and every think looks fine. When...
HI, I got the same error message even if I run this query from an SQL Server 2005 editor. Because the store procedure should be running from SQL...
Hi, I'm already using SP4. Thanks a lot Entela
Hi, I'm using a store procedure which insert, update or delete on a table on a linked server. The insert and the update is working fine, but for the...
Hi, Actually I changed my store procdure and I'm setting XACT_Abort ON, but I'm getting the following message: OLE DB provider "SQLNCLI" for linked...
Hi everyone, I got the following message: {"Unable to start a nested transaction for OLE DB provider "SQLNCLI" for linked server "GIS-GPSDB1". A...
HI, I'm not using these statements, should I? Thanks Entela
Separate names with a comma.
