we are currently having 8 tempdb files ,

we feel that database performance issues happening and alternative for this to solve by adding more tempdb and reduce the load on the...

Hi this is rohit

1] in your post you didint mentioned the company name ? and what is the company website and in which level its fall in to MNC...

Hi jeff ,

I have checked that msdb.dbo.sysjobhistory but its not giving the job name not status of the job when it failed

we need the count for number of...

In that server other than SQL server app severs will run and connect to sql from their aliases to get data and also to dump some [select insert update operations...

yes its using both CPU and Ram

I tired to check by using this command and we can see the time changed but not who changed

[ the servers is " 10.50.4000.0SP2Standard Edition (64-bit)] in version.

USE [database]

GO

SELECT sid,...

yes i have followed this but not working and its throwing errors

our environment has 2008 and 2005 sqlservers and they are standard versions in that case how can we...

Backups jobs which run from netapp its daily occurring but its should come evry time if we assume its the issue. this cpu issue is coming recently and the...

yes linked server was setup there in the server to which i has to point

and also its is created in the server 2 and its pointing to server1 and...

changing sqlserver linked server names as per security policies

as SQL01,SQL02

sample out put i got

name product provider ...

we have already created linked server before the job was created

and also checked for remote procedure rpc enabled or not

checked every thing and the linked server test connection...

its a normal job step which it runs a linked server inthat we just want what is the resolution for this

yes Gail i too agree with you i just want to test this will work or not so that only tried

Hi all i have worked on this post if any corrections suggest me.....

We can see how the Database is being Backed up in multiple files and then its being...

HI ,

Can you please, mention what are those DMVs which and can be used and what dmv for what area in the list i menitoned