I just noticed the recovery mode wasset to full, I was able to shrink it now

Dev (11/15/2011)

It worked for you but it’s not recommended (could be very risky). In worst scenario it could lead you to system crash...

well my experience with MS support is that they won't fix any of my isues or are even more lost than myself,

The solution was "easy" I changed a couple...

Thanks

I will try to install all over again

Yes i select the instance I want to upgrade

since nothing worked I tried this:

Setup.exe /q /ACTION=upgrade /INSTANCENAME=MSSQLSERVER /RSUPGRADEDATABASEACCOUNT="superuser" /RSUPGRADEPASSWORD="password" /ISSVCAccount="NT Authority\Network Service" /IACCEPTSQLSERVERLICENSETERMS

it worked on one instance but when I...

Hello

This is what I get with that query:

SOS_SCHEDULER_YIELD14335845.6532.2232.22

CXPACKET7263604.7416.3348.55

BROKER_RECEIVE_WAITFOR4317801.949.7158.26

PAGEIOLATCH_SH2793680.546.2864.54

RESOURCE_SEMAPHORE2313094.755.2069.74

BROKER_TRANSMITTER1889177.544.2573.98

WRITELOG1853443.944.1778.15

PAGEIOLATCH_EX1508445.863.3981.54

ASYNC_NETWORK_IO1161229.532.6184.15

OLEDB971904.572.1886.33

BROKER_EVENTHANDLER966467.532.1788.51

ONDEMAND_TASK_QUEUE961469.282.1690.67

PAGELATCH_EX878936.031.9892.64

LATCH_EX434981.770.9893.62

SLEEP_BPOOL_FLUSH330735.770.7494.36

PAGELATCH_SH249026.220.5694.92

LCK_M_X223864.300.5095.43

LCK_M_S223578.960.5095.93

IO_COMPLETION170426.110.3896.31

BACKUPBUFFER149666.190.3496.65

PREEMPTIVE_OS_AUTHENTICATIONOPS147068.050.3396.98

LCK_M_IX139609.950.3197.29

BACKUPIO130742.120.2997.59

ASYNC_IO_COMPLETION127503.020.2997.87

PREEMPTIVE_OS_REVERTTOSELF103287.270.2398.11

LCK_M_IS84086.940.1998.29

LCK_M_U75274.170.1798.46

PREEMPTIVE_OS_SECURITYOPS66652.980.1598.61

TRACEWRITE59115.150.1398.75

PREEMPTIVE_OS_LOOKUPACCOUNTSID49788.280.1198.86

PREEMPTIVE_OS_DELETESECURITYCONTEXT45821.170.1098.96

LCK_M_SCH_M44636.990.1099.06

Thanks, this is what I get with

select * from sys.dm_os_wait_stats order by 3 desc

Wait type--------------------Waiting task count--Wait time ms-----max wait------signal wait time ms

SOS_SCHEDULER_YIELD-------2580613123-------12811631972-------17322-------12809029011

CXPACKET--------------------955460838---------6623920160-----7045715--------1082202989

BROKER_RECEIVE_WAITFOR------1981445---------3992879800------599993-----------12265241

PAGEIOLATCH_SH--------------72526907---------2632302999-------20873-----------10017518

The result from select * from sys.dm_os_waiting_tasks...

Hi

It is on the activity monitor the Activity monitor, under resource waits/Memory

I haven't see the option to save the data into a table, that will do

Thanks all

Hello All

the issue is this:

In previous versions (2005) I set the initial size of tempdb log and after the reboot the size returns to that initial one, in 2008, after...

an easier solution is having two ip addreses on the server, one for each instance, that is already working for me

mmm sp_whoisactive is quite nice, but my last version of sp_who3 ( the one posted here is one year old) has some more useful options

Already tried that

it says thant ended succesfully but the db is still there

exactly

But that detach the whole db not only the files, if i delete the files i'll be able to attach the db again? I need to be sure since this...