Topics
Started by
Posts
Last post
I have trapped a LINQ generated tsql batch using Sql Server Profiler. It uses exec sp_executesql wi…
9 replies
I have been provided a server that is maxxed out at 6 disks. When deciding how to arrange the disk…
5 replies
Hello guys, I noticed abnormality in System Context Switches/sec counter......The average value lie…
4 replies
I took some of the screeshots of my Activity Monitor and sp_who2 stored procedure..... May be you g…
4 replies
I was just tryign to analyse what would be the dis advantages of creating too many indexes for impr…
5 replies
Howdy, For some reason my understanding was that creating an FK constraint also created an index, b…
8 replies
I see a lot of SPID's with sleeping status and the application is .NET SQLClient Data Provider To p…
6 replies
Hi All, while monitoring process on sql server on production db , i am getting waits with type ASYN…
8 replies
Hey i have a basic question In Activity Monitor most of the process id's are in sleeping state(i be…
2 replies
HI, I am seeing lots of disk IO on one of my SQL 2005 machine. After running rom Perfmon I saw at …
2 replies
If an index is being used more (or better yet, much more) than it is being updated, then it's neede…
4 replies
started doing performance monitoring and getting some crazy results. on some servers i'm seeing ove…
2 replies
I ran the profiler and got the trace file......I then used DTA to analyze the trace file....but i m…
7 replies
There is a extended procedure which got stuck....even though it get killed still in killed/rollback…
15 replies
This is on 32 bit SQL 2005 std sp3.
8 replies
Viewing 15 topics - 1,261 through 1,275 (of 3,249 total)
You must be logged in to create new topics.