Thanks for the update .

Normally we are seeing 400-450 connections in user connections counter in perfmon.

But suddenly connections increased to 1500 and cpu 100 % and site not loading...

I think u r not understanding what i am asking . I am not asking amount the memory [RAM], i want to release the Database unallocated space .

HI ,

Thanks for the update .

i run the maintenance plan again with fill factor 90 % , but i did not find any changes in the database...

Thanks for the update .

I am wondering, my database size is 28 GB , i have 26 GB free space .But still why i am getting out of...

I Googled with the same error. But i am unable to find the exact solution .

https://access.redhat.com/knowledge/solutions/120473

only error is posted , we are not finding the solution...

may be there is a chance . But why we are getting the error like related to SQL server "javax.transaction.xa.XAException: java.sql.SQLException: Failed to create the XA control connection. Error:...

Thanks for the update.

The environment is configured long back is up and running smoothly .

Two days back the application is unable to connect the DB . We...

HI ,

I had the same issue but i am using the windows 2008 .

Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d01c(error not found).

Error: 8509, Severity:...

Hi All,

Applciation team is unable to connect the DB server , immediately we checked the SQl server error log , we found the below errors.

Import of Microsoft Distributed...

Thanks ,

I got the solution for my problem .

UPDATE tablename

SET columnname = replace(columnname,'olddata', 'newdata')

WHERE columnname LIKE 'abc%';

Thanks

Lavanya

homebrew01 (1/30/2012)

---

What sort of performance problems did you find, and how did you fix them ? -- we increased the no of processors and RAM size .we did table...

Thanks for the Quick response .

Is it advisable to launch the one more site on the same DB server ?still we have some performance issues on present server ....

one more clarification table1,2,3 in different database .

table4 in another database .

Thanks Monster.

For my performance issues i am referring the below book :

SQL server 2005 administrator's companion ::

[processor bottle neck]

1.The Processor-Context Switches/sec counter should not...

HI All,

Wish you a happy new year.

In my environment every weekend maintenance plan is running with rebuild index,database integrity.I am running a perfmon counters with Available MBytes.After completing...