Viewing 15 posts - 46 through 60 (of 81 total)
We had an issue with one of the log files grow out of proportion. We haven't received any alerts. I am trying to automate the process only for the databases...
June 18, 2012 at 11:42 am
You mean to say that..........the restore job checks the time on the file it restored and deletes the older files ???
June 13, 2012 at 5:56 pm
I had the same issue------
BackupDiskFile::OpenMedia: Backup device '\\Logshipping\20120612061511.trn' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.).
But I don't...
June 12, 2012 at 12:09 pm
sure.
June 12, 2012 at 10:50 am
Done.
June 11, 2012 at 1:26 pm
we have the sql sentry tool.
I just went back to the time we saw this message and it looks like we have zero memory grants at that time.
June 11, 2012 at 9:36 am
Hi Adam,
I don't think it's a memory grant issue. I checked the grant values at that time and the value is zero. However the buffer cache hit ratio decreased from...
June 10, 2012 at 4:46 pm
SQLKnowItAll (6/6/2012)
deep_kkumar (6/6/2012)
GilaMonster (6/6/2012)
Every single query you run fails with that message?YES.
That can't be possible since you were able to run DBCC MEMORYSTATUS
Sorry. This issue was resolved when I restarted...
June 6, 2012 at 3:18 pm
GilaMonster (6/6/2012)
deep_kkumar (6/6/2012)
GilaMonster (6/6/2012)
Every single query you run fails with that message?YES.
Even SELECT * FROM (VALUES (1)) sub(a) ?
Select @@version?
not these queries.............i tried to check what's running on the server...
June 6, 2012 at 3:16 pm
David Benoit (6/6/2012)
Being that you have 128 GB of memory I am assuming that this is 64-Bit but just to be sure, is it?
YES
June 6, 2012 at 3:02 pm
GilaMonster (6/6/2012)
Every single query you run fails with that message?
YES.
June 6, 2012 at 3:02 pm
GilaMonster (6/6/2012)
What's the query? (btw, this has to do with workspace memory grants, not necessarily the available buffer pool)
this error blocks all the queries to run. All the jobs failed...
June 6, 2012 at 2:49 pm
Memory Manager KB
---------------------------------------- -----------
VM...
June 6, 2012 at 2:45 pm
Viewing 15 posts - 46 through 60 (of 81 total)