At first I thought the database has size problem, so I extended the file size of tempdb, but I was still not able to see the properties of tempdb, and I confirmed that the there was enough free space in tempdb.
Then I checked the sql errorlog file, there was no error message. Sql server looks good.
Then I run profiler trace, and monitor the whole process when I clicked "Properties" menu. unfortunately, there was still no error message regarding tempdb.
I thought it might be a client problem, not sql server problem, so I enabled the "User Error Message", this time I got an error message: "Lock request time out period exceed"
the last script showed in the pic upper was the problem script. It was blocked by other session, so the lock request timeout, then SSMS raised up the error message Property Size is not available for Database "[tempdb]"
Obviously it was a simple blocking issue. next step is trying to find out the blocking script. I reproduced the error message, at the same time, checking the blocking script
so the blocking session is 79, and wait resource is key 2:327680. I got the table and index name with the script below:
and session 79 had xlock on the key 2:327680
but why SSMS queried table sysrowsets when I clicked "properties" menu? by checking the timeout query, it will retrieve data from sys.partitions table, and sys.partitions table is a view based on sys.sysrowsets
as to why session 79 had xlock on sys.sysrowsets , it was running a very big transaction involving some temp tables and some complicated queries, and I can not change the code of that application, so the only way was waiting it finish, but at least I know the tempdb is fine and sql server is runnning well, I can totally ignore this error :)
the last script showed in the pic upper was the problem script. It was blocked by other session, so the lock request timeout, then SSMS raised up the error message Property Size is not available for Database "[tempdb]"
Obviously it was a simple blocking issue. next step is trying to find out the blocking script. I reproduced the error message, at the same time, checking the blocking script
so the blocking session is 79, and wait resource is key 2:327680. I got the table and index name with the script below:
and session 79 had xlock on the key 2:327680
but why SSMS queried table sysrowsets when I clicked "properties" menu? by checking the timeout query, it will retrieve data from sys.partitions table, and sys.partitions table is a view based on sys.sysrowsets
as to why session 79 had xlock on sys.sysrowsets , it was running a very big transaction involving some temp tables and some complicated queries, and I can not change the code of that application, so the only way was waiting it finish, but at least I know the tempdb is fine and sql server is runnning well, I can totally ignore this error :)
Many issues mention about cockfight in philipine, we are from ayam bangkok caruban want to explain that. You can read our article. Thanks.
ReplyDeleteAWESOME THE PROMOTION OF GIRL BEAUTIFUL SALES KLIK HERE SABUNG AYAM
ReplyDeleteGOOD PRICE AND CHEAP
http://www.gorengayam.com
PLEASE PRICE DIRECTLY
https://123gorengayam.wixsite.com/gorengayammarketing/blog-1/4-ciri-jalu-pada-ayam-petarung-yang-mematikan
Link Alternatif S1288poker
ReplyDeleteS1288poker Judi Poker Online
CS S1288poker
S1288poker Indonesia
Link Alternatif S1288poker
ReplyDeleteS1288poker Judi Poker Online
CS S1288poker
S1288poker Indonesia
Bila membahas asyiknya permainan kartu online ini memang tiada batas. Namun ketahuilah kalau kamu akan selalu mendapatkan hal baru yang sebelumnya kamu tidak ketahui dari permainan judi online terpercaya. Dan dari sanalah istilah "konklusi" dimulai pada game (Baca Selengkapnya...)
ReplyDeleteApa arti taruhan 1X2 ? Bagaimana cara hitung rumus main 1X2? Jenis Bet 1X2 Sbobet dalam taruhan bola umumnya juga dikenal dengan sebutan "fix-odds". Bila kita sebelumnya sudah pernah bermain bola taruhan handicap (Baca Selengkapnya Disini...)
ReplyDeleteBA Exam Result - BA 1st Year, 2nd Year and 3rd Year Result
ReplyDeleteBsc Exam Result - Bsc 1st Year, 2nd Year and 3rd Year Result
BA Revaluation Result 2019
ReplyDeleteNikmati Kemudahan DEPOSIT PULSA di Donaco Poker...
ReplyDeleteProses Cepat dan Mudah..
DEPOSIT VIA TELKOMSEL
DEPOSIT VIA XL
DEPOSIT VIA AXIS
Mainkan Permainan Dengan Kemenangan Tinggi menggunakan 1 user ID di Donaco Poker...
* POKER
* DOMINO
* BANDAR CEME
* CAPSA SUSUN
* CEME KELILING
* SUPER TEN
* OMAHA
Daftar Poker Deposit PULSA ==>> Disini <<==
Dapatkan Juga Tips Cerdik Bermain Poker DIsini Tips Cerdik Poker
Hubungi Kami Secepatnya Di :
LINE : Donaco.poker
WHATSAPP : +6281333555662
Thanks for sharing is so amazing and helpful to us.
ReplyDeleteBuy Hydrocodone online
ReplyDeleteBest Article buy Pain Pills online Excellent post. I appreciate this site. Stick with it! Because the admin of this web page is working, no doubt very quickly it will be well-known, due to its quality contents.This website was how do you say it? Relevant!! Finally, I’ve found something that helped me.
Best Article buy Roxicodone online Excellent post
buy Xanax online
buy Oxycodone online
Best Article buy Pain Medications online Excellent post. I appreciate this site. Stick with it! Because the admin of this web page is working, no doubt very quickly it will be well-known, due to its quality contents.This website was how do you say it? Relevant!! Finally, I’ve found something that helped me.
buy Research Chemicals online
buy Roxicodone online
buy Cbd Isolate online
Thanks a lot for sharing
ReplyDeleteHaving good health is what most people out there wants but can not achieve. some people takes buy ibogaine online AND buy weed online to get it.
Bingung Cari Agen Poker Terpercaya??
ReplyDeletePercayakan Kepada DonacoPoker...
Agen Profesional Yang Sudah Lama Berkembang...
Proses Transaksi Yang Cepat dan Aman Dengan Pelayanan Yang Ramah dan Memuaskan..
Deposit mudah via Bank, Ovo, dan Deposit Pulsa
DEPOSIT VIA TELKOMSEL
DEPOSIT VIA XL
DEPOSIT VIA AXIS
Dapatkan Juga Tips Cerdik Bermain Poker DIsini Tips Cerdik Poker
Hubungi Kami Secepatnya Di :
WHATSAPP : +6281333555662
Good Blog, well descrided, Thanks for sharing this information.
ReplyDeleteBig Data and Hadoop Online Training
medical care is what many people lack in the interior areas of the world. people face a lot of health issues everyday without solution. buy psychedelics online, Buy weed online, Buy fantanyl patches online
ReplyDeleteWonderful Blog. Very helpful however I want to know from where to enable the "User Error Message".
ReplyDeleteBuy moonrock online
ReplyDeleteBuy fantanyl patches online
buy cocaine online
Bolivian Cocaine
Colombian Cocaine
Heroin
Mexican Cocaine
Buy moonrock online
Buy fantanyl patches online
buy cocaine online
Bolivian Cocaine
Colombian Cocaine
Heroin
Mexican Cocaine
Afghan Kush
ReplyDeleteAK-47
buy weed online
AK-47 dank vape
painkiller
cocaine
Amnesia Haze
buy weed online
Afghan Kush
legit online dispensary shipping worldwide
buy weed online
painkiller
buy weed online
cocaine
Amnesia Haze
ReplyDeleteBUY WEED ONLINE
BUY IBOGAINE ONLINE
BUY XANAX ONLINE
BUY DANK VAPE ONLINE
BUY COCAINE ONLINE
BUY IBOGAINE CAPSULES ONLINE
BUY LSD ONLINE
BUY BLUE DREAM DANK VAPE ONLINE
BUY MOONROCKS ONLINE
BUY CARFENTANYL ONLINE
Hi there colleagues, good paragraph and good urging commented here, I am genuinely enjoying by these. KU BA 1st Year Result
ReplyDeleteThanks for sharing What an interesting site you have i really take a good look buy cocaine online and you can also take a good look at our blog too for more information buy crack cocaine online we also recommend you to take a good look at this site too they have good content buy mdma crystals online more of the site still want you to take a closer look too as they have really good content buy crystal meth online thanks for using your time to check on the link .order cocaine online
ReplyDeletehttps://k2incenseonlineheadshop.com/
ReplyDeleteinfo@k2incenseonlineheadshop.com
k2incenseonlineheadshop Buy liquid incense cheap Buy liquid incense cheap For Sale At The Best Incense Online Shop
https://bestmjstrainsonline.com/
ReplyDeleteBuy liquid incense cheap | cheap herbal incense | buy k2 E liquid | k2 spray
Description
Buy liquid incense cheap . cheap herbal incense . buy k2 E liquid . buy k2 paper spray online . buy herbal incense online . buy k2 spice online
Buy K2 Infused paper spray online, order K2 Spray online +1 (925) 526-5453
https://bestmjstrainsonline.com/product-category/buy-liquid-incense-online/
https://bestmjstrainsonline.com/product-category/infused-drugs-on-paper/
https://bestmjstrainsonline.com/product/5-co2-cannabis-oil-cartridges/
https://bestmjstrainsonline.com/
ReplyDeleteBuy liquid incense cheap | cheap herbal incense | buy k2 E liquid | k2 spray
Description
Buy liquid incense cheap . cheap herbal incense . buy k2 E liquid . buy k2 paper spray online . buy herbal incense online . buy k2 spice online
Buy K2 Infused paper spray online, order K2 Spray online +1 (925) 526-5453
https://bestmjstrainsonline.com/product-category/buy-liquid-incense-online/
https://bestmjstrainsonline.com/product-category/infused-drugs-on-paper/
https://bestmjstrainsonline.com/product/5-co2-cannabis-oil-cartridges/
https://syntheticworldwide.com/
ReplyDeletesales@syntheticworldwide.com
Buy cheap liquid herbal incense at your best online shop
Buy weed online
ReplyDeleteOrder marijuana online
Buy Hybrid Weed strain online
sativa weed for sale
where to buy liquid herbal incense
ReplyDeletebuy herbal incense with debit card
buy herbal incense overnight shipping
strongest liquid incense
buy herbal incense online cash on delivery
liquid herbal incense 2020
k2 spray that get you high for sale
buy herbal net
super strong herbal incense
herbal incense paper
joker herbal incense
herbal incense uk
herbal incense recipes
buy herbal incense online cash on delivery
smoking blend oils review
buy shatter online in united states
buy shatter online cheap usa
mail order dabs usa
cbd online dispensary
buy firebars online
mail order concentrates
extracts shatter
15 shatter canada
buy herbal incense overnight shipping
buy herbal incense online cash on delivery
buy herbal incense with debit card
buy herbal incense online overnight shipping
cheap strong herbal incense
super strong herbal incense
most potent herbal incense on the market
trusted herbal incense sites 2020
Buy Dank Vapes Online | Dank Vapes Full Gram Cartridges.Buy Dank Vapes Online - Vape pens & Cartridges USA and .
ReplyDeletehttps://buydocumentation.com/
Buy Driver’s License online, US driver license, drivers license renewal ca WhatsApp +1 (925) 526-5453
Here at Buy Documentation, you can buy fake documents at a fraction of a cost. We keep our prices low to meet the needs of all our customers. We provide Best Quality Novelty Real and Fake IDs and Passport, Marriage Certificates and Drivers license online
https://buydocumentation.com/canada-visa/
https://buydocumentation.com/buy-real-drivers-license/
https://buydocumentation.com/buy-real-id-cards/
https://buydocumentation.com/social-security-number-ssn/
butyrfentanyl for sale
ReplyDeletebuy dextroamphetamine powder
can i buy benzocaine powder over the counter
buy tussionex cough syrup online
buy dexmethylphenidate online
Buy bzp powder
bzp for sale
Buy mdai online
where to buy fake driver license online
ReplyDeletebuy fake id with paypal
florida fake driver license
california fake driver license
colorado fake driver license
fake california driver license
michigan fake driver license
Maryland fake driver license usa
texas fake driver license
fake id
make fake driver license online
make fake id online
buy fake id online
fake texas driver license
georgia fake driver's license
uk fake driving license
michigan fake driver license
fake oklahoma driver license
oklahoma fake driver license
illinois fake driver's license
Mississippi fake driver license
fake driving license
fake illinois driver's license
georgia fake driver's license
uk fake driving license
North carolina fake drivers license
missouri fake driver license
fake missouri driver license
pensylvannia fake driver's license
fake pensylvannia driver's license
new jersey fake auto driver license
fake new jersey auto driver license
new york state fake driver license
fake new york state driver license
connecticut fake drivers license usa
ohio fake driver's license
fake ohio driver's license
buy ohio fake driver's license online usa
michigan fake driver license
ReplyDeleteMaryland fake driver license usa
texas fake driver license
fake id
make fake driver license online
make fake id online
buy fake id online
fake texas driver license
georgia fake driver's license
uk fake driving license
michigan fake driver license
fake oklahoma driver license
oklahoma fake driver license
illinois fake driver's license
Mississippi fake driver license
fake driving license
fake illinois driver's license
georgia fake driver's license
uk fake driving license
North carolina fake drivers license
missouri fake driver license
fake missouri driver license
pensylvannia fake driver's license
fake pensylvannia driver's license
new jersey fake auto driver license
fake new jersey auto driver license
new york state fake driver license
fake new york state driver license
connecticut fake drivers license usa
ohio fake driver's license
fake ohio driver's license
buy ohio fake driver's license online usa
We are proud to say that all our products are not displayed online without going through an intensive quality assurance process.
ReplyDeleteBuy clonezapam powder online
Buy cocaine online
Buy bio cocaine online
actavis-promethazine-codeine for sale online
Buy cocaine online
Buy marijuana online
Buy Martian Moonrock online
Buy kurupts moonrock online
Buy blue dream online
Buy Death Star Marijuana online
Buy vyvanse online
Buy ritalin online
Buy Godfather OG online
Buy Pineapple Express online
Buy Research Chemical online
Buy 4-cprc-crystal online
Buy 4-mpd-crystal online
Buy dibutylone crystal online
jack russell for sale uk
ReplyDeleteI wish to say that this 3rd year exam date post is amazing.
ReplyDeleteI enjoyed your blog Thanks for sharing such an informative post. We are also providing the best services click on below links to visit our website.
ReplyDeleteOracle Fusion HCM Training
Workday Training
Okta Training
Palo Alto Training
Adobe Analytics Training
to the medical condition of most patients. many people suffering from cancer, chronic pain, anxiety and man more have overcome their illment with cannabis. you can order weed from our store
ReplyDelete
ReplyDeletemarijuana has been a stepping stone to the medical condition of most patients.
many people suffering from cancer, chronic pain, anxiety, and many more have overcome their aillment with cannabis.
you can order weed from our store.medical condition
ReplyDeleteOur online store is one of the best in the supply of rare and high-grade (Mushrooms, Edibles. Psychedelics, and more)with absolute purity. All our products are tested to guarantee potency after production, during distribution and even storage. We ship globally in discreet and undetectable packaging using our network of trusted partners.
psilosybin mushroom 2022, trusted magic mushroom site 2022,
cheap liquid lsd, order cheap psychedelic mushroom,
cheap magic mushroom, super quality shrooms,
most potent psilocybin mushroom on the market,
best microdosing mushrooms 2022, Golden teacher mushroom for sale,
where to buy B+ magic mushroom, buy shrooms online ,
buy psilocybin mushroom overnight shipping, effective microdosing for ptsd,
buy mushroom truffles online cash on delivery, buy microdose capsules online 2021,
magic mushrooms for mental illness for sale,
buy mushies for anxiety/deppression and ptsd, cheap psilocybin mushroom, shrooms near me,
where to buy psilocybin mushroom near me, cheap psychedelic mushroom for sale,
buy caps/buttons cheap, best place to buy magic mushroom,
buy cheap fungi mushrooms, cheap strong fungus, best quality spores for sale,
buy mushroom grow kit online, buy fungi shrooms near me, cheapest magic mushrooms online,
where to buy penis envy online, where to buy mexicanna online, buy microdose capsules online,
best microdose capsule for sale,
fungi mushroom for sale, best liquid cultures online, buy spores near me, buy Nirvana mushroom near me,
buy pajaritos mushrooms near me, psychedelic mushroom near me, buy medicinal mushroom online,
buy 5-MeO-DMT, buy dmt vape pen online, buy lsd tabs online, buy dmt online, where to buy dmt,
lsd for sale, buy mushies near me, buy shrooms wholesale price, strong boomers for sale,
Buy trippy shrooms online, buy penis envy, buy albino A+, buy amazonian cubensis,
buy psilocybe cubensis, buy blue meanie, buy vietam cubensis, buy z strain shrooms,
buy boomers cubensis online, buy cubensis buy golden teacher, buy liquid lsd online
Our quality is the best you can find around and we sell in small/large quantities with guaranteed discreet delivery in good time Shipping
website...https://megapsilocybin.com/
call/text..+1(458) 201-6900
email..sale@megapsilocybin.com
Most valuable and fantastic blog I really appreciate your work which you have done about the electricians,many thanks and keep it up. Very useful info. Hope to see more posts soon! I really like to read this post, it shares lots of information to readers.a
ReplyDeleteGraphic Design company in USA
Label Design
Box Packaging Design
Packaging Host
Die Cut Stickers
Static Cling
Lahore Smart City Payment Plan
Hosting Mart
Lahore Smart City
ReplyDeleteHow to get Covid-19 Vaccine Certificate without vaccine
Best place to buy covid card online payment
Buy covid-19 vaccine Certificate Online USA
Where to Get COVID-19 Vaccine Card
ReplyDeletelegit online dispensary shipping worldwide
Order Marijuana online shipping worldwide
legit online dispensary shipping worldwide
ReplyDeletemost trusted online dispensary ship all 50 states
Order Marijuana online Shipping worldwide