Viewing 15 posts - 16 through 30 (of 63 total)
This solved my issue! There was collation conversion between tables, I have standardized the collations. Now its very fast, thanks Gila. How did you see the conversion in sqlplan?
Nolocks were...
September 25, 2011 at 9:43 am
Any more ideas?
September 22, 2011 at 11:17 am
Thanks, I will gradually revoke all public and guest permissions,
Have a nice day.
September 21, 2011 at 12:58 am
Your bet was right.. Somebody has given all database level permissions to public role and guest user (there is no guest role, its a user but not mapped to a...
September 20, 2011 at 8:35 am
No, unfortunately not the owner of the database (my own account is db owner) , only public server role is selected for the login. Any ideas??
September 20, 2011 at 8:03 am
Is has to read and write data, what we don't want is create, alter tables, db_denydatawriter will stop read and writes I think.. Can it be related to guest or...
September 20, 2011 at 7:29 am
Nope, sessions are still there in KILLED/ROLLBACK status, I think they will be until service restart.
May 23, 2011 at 3:16 am
No, I set it to 1, to see if the self blocking sessions will resolve, but no change..
May 18, 2011 at 2:05 am
I guess so too, any thoughts how to resolve it? Changed maxdop to 1, but no change..
May 18, 2011 at 12:37 am
Yesterday we could manage to backup transaction log from only a .ldf file as:
1-Created a new dummy database
2-Stop SQL service
3-Replace the dummy database's .ldf with our .ldf, (put to...
May 5, 2011 at 12:54 am
This is a consolidated environment and no complaints arrived yet but I have buffer cache hit ratio as 97%, as far as I know this denote a memory pressure..
February 11, 2011 at 4:36 am
But there are no running or waiting queries, so there should be no query running at the time, problem is transactions not committing for hours, probably due to a mishandling...
December 30, 2010 at 12:33 am
Yes I can see the locks with
select * from sys.dm_tran_locks
Also see tran at:
select * from sys.dm_tran_active_transactions
as implicit transaction
Is there any solution to blocking? Implicit Transaction seems open for 6...
December 29, 2010 at 10:08 am
Viewing 15 posts - 16 through 30 (of 63 total)