SQLRNNR

Forum Replies Created

Viewing 15 posts - 5,206 through 5,220 (of 19,560 total)

RE: how do I know files are backed up in tapes

Keep in mind that unless you test restore the files - you have no backup.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 14, 2013 at 9:08 am

#1576949
RE: SQL Query causing CPU Spikes on SQL Server 2008 r2

On the server with the CPU spikes, please check the BIOS settings for Energy Saving features.
If enabled, disable them.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 14, 2013 at 9:00 am

#1576947
RE: New more powerful servers are slower than old ones?

sotn (1/14/2013)
I think this is fixed.
We have found that the CPU settings in the bios were set to balanced
Thanks SQLRNNR for the pointer.
A 'real' workload before changing the setting now...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 14, 2013 at 8:54 am

#1576941
RE: Upgrade to sql 2012 this year: BMC Patrol versions

Indianrock (1/14/2013)
I was given a document outlining the installation of the BMC Patrol for sql server 4.3.2 agent ( 2009 ), which is to be installed on the monitored servers....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 14, 2013 at 8:13 am

#1576923
RE: Is it even possible?

Jeff Moden (1/13/2013)
SQLRNNR (1/13/2013)
What should the output look like?
😛
Ok, that makes sense then.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 13, 2013 at 8:31 pm

#1576748
RE: Is it even possible?

What should the output look like?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 13, 2013 at 7:53 pm

#1576744
RE: four part naming not woprking

Here is a similar thread. See if it helps.
http://www.sqlservercentral.com/Forums/Topic439890-149-1.aspx#bm440689
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 13, 2013 at 7:45 pm

#1576743
RE: how do I know files are backed up in tapes

You need to explore the tape index/catalog/contents to see if the files were backed up. Better yet is to test restore from tape.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 13, 2013 at 7:40 pm

#1576741
RE: Upgrade to sql 2012 this year: BMC Patrol versions

From what I gather it is more geared to the OS rather than SQL server. If you need to have purchased software to monitor, I prefer to stick with...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 13, 2013 at 7:39 pm

#1576740
RE: Report Parameters Selected Shown in Report and/or Footer

In parameter properties, go to available values. You set the label on this screen.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 12, 2013 at 9:22 pm

#1576656
RE: Global Insecurities

Now if only the vendors would agree to use the information.
That would be great. It would be great if on the occasions that vendors do publish something, they would...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 12, 2013 at 5:40 pm

#1576646
RE: T-SQL 2012 #2

Glad we have this feature added.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 12, 2013 at 5:18 pm

#1576645
RE: Report Parameters Selected Shown in Report and/or Footer

Yes you can do that.
It sounds like you use drop boxes for each parameter. In the properties there is a label field. I add that Parameter label to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 12, 2013 at 5:13 pm

#1576644
RE: Employer asking for Social Media login?

I would never give any of my social media accounts to somebody else.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 12, 2013 at 4:57 pm

#1576642
RE: IO Errors

Change your order by to Avg Physical Reads. The Total Avg in that query has physical reads plus logical reads.
Starting with IO is a good start. ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 12, 2013 at 9:09 am

#1576600

Viewing 15 posts - 5,206 through 5,220 (of 19,560 total)