Viewing 15 posts - 12,886 through 12,900 (of 49,552 total)
Ignore it. It's a sleep wait, meaning it's logged because some process is sleeping.
June 5, 2013 at 5:16 am
Sqlfrenzy (6/5/2013)
What if the GUI is connected through a different server/machine.. i.e. say from UAT/dev server. will the performance impact is same in this case?
Even worse.
June 5, 2013 at 2:47 am
hvermaak (6/5/2013)
How would you approach the problem to find the query or the data is affecting the environment?
Server-side trace as explained in the two articles from Simple Talk.
June 5, 2013 at 2:33 am
hvermaak (6/5/2013)
Open profiler,File, new trace.
Connect to your sql server.
Use the template -> select Tuning
select save to file -> choose a location with sufficient space
I would strongly recommend not running...
June 5, 2013 at 2:16 am
You can't change someone else's database context. Find whoever's running session 53, ask them to change to master.
June 5, 2013 at 2:11 am
SQL Geek (6/5/2013)
Hi SQLSACT, There is no wait only the CPu utilization is 90-100%.
CPU usage at 100% in no way indicates or suggests that there's too much network traffic.
In...
June 5, 2013 at 2:10 am
SQL will send the application the data that it requested, it won't send random stuff without some app querying it. If the application is requesting too much data, tune the...
June 5, 2013 at 1:01 am
I'd suggest that the performance problem is a secondary concern. That trigger will only work correctly if a single row is updated. Any time there's more than one row changed,...
June 4, 2013 at 11:55 pm
When you're rebuilding offline, the index will be unavailable, the rebuild process takes a schema modification lock, which blocks all access to the table.
June 4, 2013 at 11:34 pm
PHXHoward (6/4/2013)
I assumed if the writes were significantly more than reads than the index is bad.
For a nonclustered index, yes in general, but the clustered index is the table, hence...
June 4, 2013 at 3:35 pm
Spatial data? There's no relation between spatial data types (geometry and geography) and database snapshots.
No, there's no way to create the database equivalent of VM's differencing disks. Restore the users...
June 4, 2013 at 3:05 pm
Probably not.
What in those numbers suggests to you there's a problem? Looks just like heavily modified tables.
June 4, 2013 at 3:03 pm
The SSMS debug 'feature' requires that the person using it is sysadmin.
To be honest, that 'feature' is probably one of the worst debuggers around, there are much better ways of...
June 4, 2013 at 3:02 pm
Viewing 15 posts - 12,886 through 12,900 (of 49,552 total)