hi yes i checked and double check in the properties of the DB that i am checking the correct files.

when i click on the file and you get a...

thanks!! i don't have any cursors in the stored procedures.

according to the article a select can cause a deadlock

i will check on table structures as well as indexing....

i fixed the problem by

SELECT TABLE_NAME, CONSTRAINT_NAME

FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS

WHERE CONSTRAINT_NAME LIKE '%PK%' --adding this line

ORDER BY TABLE_NAME

and it...

Thank you guys! 🙂

thank you!

hello, by using this query select * from sys.dm_os_performance_counters

where counter_name = 'Buffer cache hit ratio'

i get :

cntr_value cntr_type

2660 ...

The C drive is 19.5 GB, i have 2 GB left of free space.

My tempD is 5083 MB with available 4846 MB.

both my DBs are used for read...

hi i will find out my RAID configuration,

this is what i know:

ALL NTFS, Partition

Disk 0

C and D drive

Disk 1

E drive

Disk 2

F...

hi, don't worrry ask as many questions as you want, yes it is full with simple recovery model, i have both my Dbs as autogrowth, by 10% , unrestricted.

hello, by using this query select * from sys.dm_os_performance_counters

where counter_name = 'Buffer cache hit ratio'

i get :

cntr_value cntr_type

2660 ...

right now i have the data files from my new DB in the same physical drive as the one i had before, if i move them to a different drive...

i checked task Manager and this is what I see:

Physical Memory (k)

Total 4193000

Available 107600

System Cache 217240

Kernel Memory (k)

total 152470

page 116820

Nonpaged 35020

I also checked the Performance monitor

for Counter Pages/sec...

hi , how are you checking how much of RAM your sql server is consuming?

hi i am having the exact same error, did you fix your problem?

thank you!!