Hi,

Can you please provide the script to send alerts for altering sql logins in sql server?

thats the problem

both the accounts have been disabled

and i don't have any other SA account available there.

do i have any other way ?

(other than reinstalling server)

anyone has idea???

plz suggest

MarkusB (12/1/2008)

---

What exactly are you looking for?

The CPU usage by SQL server in general or the CPU usage for a query?

You can find some information about the general CPU...

are u sure?

how will i map logins to those credentials?

Hi Gail,

i have already seen the links u provided, my concern is where & how those credentials are used?

do u have any practical example ?

thanx Kevin

But i took that decision of splitting tempdb in multiple files is becoz, i was getting bufferlatch wait type

also it was indicating PAGELATCH_EX,PAGELATCH_UP also resource_Type was 2:........ and all...

Additional info

SQL server 2005 SP3 service satrted with domain account "domain\lqss"

Lock pages in memory enabled (with domain\lqss)

Maxserver memory 10gb

min server mem 4gb

AWE enabled

Max...

Locations of tempdb files

namefileidfilename

tempdev1D:\TempDB\tempdb.mdf

templog2C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\templog.ldf

tempdb23D:\TempDB\tempdb2.mdf

tempdb34D:\TempDB\tempdb3.mdf

tempdb45D:\TempDB\tempdb4.mdf

tempdb56D:\TempDB\tempdb5.mdf

tempdb67D:\TempDB\tempdb6.mdf

tempdb78D:\TempDB\tempdb7.mdf

tempdb89D:\TempDB\tempdb8.mdf

C:\ and D:\ drives are on same disk

RAM -16GB (10GB dedicated to SQL)

CPU- 8 Cores,16 threads

but why tempdb will cause insert operation to get...

Hi Gila,

As of now no one has complained about nolock from User side since the SPs in which nolock is used are getting executed after every 3 seconds which reads...

Thanx for Reply

But i need to check disk io performance, can u plz suggest from where i should start?

also in my application inserts are getting slower(only when i start another...

thanx a lot jim, u saved my life..............

hi friends

do u want any more information?

plz need ur suggestions !!!!

currently we are using sql server 2005

though i m not SSRS developer but still i m curious abt sql server 2008 SSRS

this helps us to monitor remotely all the production...