Hi,

Please consider this scenario, if you have a PRDO box and some ADHOC query which was not properly tested in DEV/UAT was resource expensive and blocking others and your last...

Sourav,

No options as to my little knowledge 🙁

Let me know the solution once done.

Thanks,

Raj

Sourav,

As I stated before, if it’s a PROD box better to leave it like that still it doesn’t create a big issue.

I agree with RBarry and Jeffrey .. u better...

Welcome, what is the output of the sysprcoesses for the SPID 77?

IO, CPU changing? What’s the rollback percentage? What is the lastwaittype ?

Thanks,

Raj

Sourav,

If the transaction was big then it will take some time because it has to rollback the transaction completely.

It’s better to monitor if the IO and CPU is changing or...

Hi

Execute the below query to see what are the SPIDs with more CPU

USE [master]

GO

SELECT * FROM sysprocesses

ORDER BY cpu DESC

And run DBCC INPUTBUFFER(SPID) or fn_get_sql() to find more about...

azhagumuthu

As to my knowledge it’s just showing the number of CPU nodes.

And it is also for informational message only.

Is it first time coming after you configured NUMA?

Thanks,

Raj

DoubleEx

Check the login and privilege details of the login that the web application is using.

Try to check is the Users and Login are synced in the new server and currently...

Edwin,

Jeffrey wants to say to use Replace Function to achieve your goal as the below select statement

SELECT REPLACE (DefEmail,'@company1.com','@NewCompany.com')

FROM dbo.table_test

The same can be done for update statement and if the...

Tara,

Is the SPID getting changed?

Is the SPID value is less than 50?

What is the Version of your SQL Server?

Thanks,

Raj

Hi,

I have a problem, my server is not recycled in a frequent basis and we have audit enabled so the Error Log Size is too big.

We also don’t follow any...

Thanks a lot Boolean_z,Rajesh kasturi,SA.

I just need little update how to read error log after a date or time specified.

sp_readerrorlog ?

Hi Jonathan,

Thanks for the reply, but from which table I can find xstatus in SQL Server 2005.

Regards,

Raj

Kokila,

Please find the below post .

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=1015696&SiteID=1

Is there any Third Party Database Related Software installed like Log Rescue or Monitoring agent?

Regards,

Raj

I will present a scenario

:)Your Customers says to start a new production Server at 9:00 AM.

:)You started your production servers at 9:00 AM.

:)Transaction Started.

:)Database is in Full Recovery Model.

:)Your...